This discussion is archived
1 Reply Latest reply: Mar 2, 2011 8:45 AM by 843452 RSS

sqlplus as sysdba with database and script to run specified

843452 Newbie
Currently Being Moderated
We have a script that we run which goes to multiple databases using the statement:
sqlplus userid/password@database @scriptname.sql

Is there a way that I can code this to run sqlplus /as sysdba and specify the database and script as above? Without having to hard-code the sys password into the command?

Edited by: user8632754 on Mar 1, 2011 11:19 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points