RE: Script for Import 29000000 lines in background and to create

From: Stephen Lee <slee_at_dollar.com>
Date: Sun, 20 Oct 2002 21:48:23 -0800
Message-ID: <F001.004EE66B.20021020214823@fatcity.com>

-----Original Message-----

1.) imp user/passwd file=file.dmp fromuser=user1 touser=user2 rows=y log=log1;

---

Please be aware that running your scripts in this manner will show the user and password to anyone who gets on the box and executes ps -ef.

Also, running sqlplus -s user/password_at_SID while do the same thing.

To keep this from happening, either put the user and password in a file readable only by you and redirect from the file into the imp command; or use a shell "here document" as in:

imp arg arg arg <<-XXX
user/password
XXX Another way to run things in the background in such a way that they don't get whacked by an interrupted terminal connection is to put write your script then use the command something like:

echo "/path/script_name arg arg arg > /some/logfile 2>&1" | at now

Or just put the command into your crontab for five minutes from now.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Stephen Lee
  INET: slee_at_dollar.com

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: ListGuru_at_fatcity.com (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). Received on Mon Oct 21 2002 - 00:48:23 CDT