-2

I have a remote instance like database-ora12 with existing user tester / password and SID=orac

How I can delete remotely database or schema from this system for this user using shell script without SQLPlus.

Adding more details:

  • Instances from where shell script executed = hcuser, bkuser
  • Oracle Instance on which oracle db exists = database-ora12
  • Oracle username = tester for hcuser / btester for bkuser
  • Oracle password = password
  • SID = orac

As mention above, a script uses to delete or drop the schema on oracle instance from different shell instances.

Improve this question
3
  • 4
    Why can't you use sqlplus? What have you tried so far and what was the result? Commented Sep 5, 2018 at 18:19
  • 1
    I've removed the sqlite tag because it's got no relevance whatsoever to an Oracle database. I've also changed oracle to oracle-database. Commented Sep 5, 2018 at 21:06
  • @Jeff: currently the system administerator don't want to install sqlplus on linux systems where script will going to execute. Commented Sep 6, 2018 at 5:30

1 Answer 1

Reset to default
1

If you don't want to use SQL*Plus, you are going to find it tricky to perform any database schema operations from a shell script.

You could write a Pro*C application (or something equivalent), use Perl's DBI and DBD::Oracle modules, or the equivalent in a language such as Python or PHP.

Improve this answer
1
  • Though these also require Oracle client to be installed, and it is unlikely to install Oracle client without Sql*Plus. Commented Jan 31 at 11:20

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.