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