RE: How to stop script

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Tue, 17 Jun 2003 01:45:53 -0700
Message-ID: <F001.005B2B3B.20030617012918@fatcity.com>

Hi Chen,

My solution will be about the same with previous DBA guru

I assume u r using Window (if is unix you just need to change a little bit here and there)

I write this script for you.

+++++++++++++++++++++++++++++++++save as imp.sql++++++++++++++++++++++

SET HEAD OFF
SET FEEBACK OFF
SET PAUSE OFF
SET VERIFY OFF
SET LINESIZE 250 SPOOL 'C:\temp\~dynamic_imp.bat'
SELECT 'imp username/password@' || name || ' full=y file=bla bla other parameter=bla bla bla log=mypath\log'
from v$database
where name = 'TEST';

SPOOL OFF

host chmod u+x C:\temp\~dynamic_imp.bat (if you using unix this will prevent you from bug cause by your umask)
host C:\temp\~dynamic_imp.bat -- uncomment this if you ready to do the import
host del C:\temp\~dynamic_imp.bat -- uncomment this if your C:\temp\~dynamic_imp.bat is look ok

++++++++++++++++++++++++++++++++++++++++++++++++++=

+++++++++++++++++++++++++++++save as imp.bat***************************

sqlplus -s someone_can_do_select_v$database/[EMAIL PROTECTED]

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

You can add alot of fancy stuffs but the concept is about like that

Sinardy

-----Original Message-----
Sent: 17 June 2003 12:39
To: Multiple recipients of list ORACLE-L

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: Sinardy Xing
INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------