Re: How to stop script

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