You could use a little indirect approach in this case. The file import.sql will look like this
set feed off set lines 120 set trimpsool off set pages 0 spool imp.sh select 'imp un/[EMAIL PROTECTED] file=a.dmp full=yes' from v$database where name = 'TEST' / spoo off exit You have another script called call_import.sh with the follwoing lines sqlplus -s us/[EMAIL PROTECTED] @import.sql sh imp.sh If the database is not test, then the imp.sh will be empty and the import will not go through. Otherwise it will have the entire import line. HTH. Arup Nanda ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 12:39 AM > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda 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).
