In Oracle 9i we use "sqlplus -s @start_mydb.sql" to start the database. But, where as in Oracle 10g this command simply hangs and will not do anything.
To invoke SQLPLUS in shell/bat scripts in Oracle 10g, We need to give below command.
sqlplus /NOLOG @start_mydb.sql
Regards,
Sabdar Syed.
Sunday, April 15, 2007
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment