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).
