Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> How to stop script
I have a script and can be run on commandline like:
> sqlplus <usrname>/<password>@TEST @import.sql
However, I want to check database name at the beginning of import.sql. I knew "select name from v$database" can obtain database name. But how can I stop the script if I found it is not TEST database? In import.sql, it is like:
drop user A cascade;
create user A ....;
host imp A/[EMAIL PROTECTED] file=a.dmp full=yes;
// some PL/SQL ...
Thanks!
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Jun 16 2003 - 23:03:12 CDT
![]() |
![]() |