Oracle-L: RE: Import Problem

From: Richard Ji <richard.ji_at_mobilespring.com>
Date: Mon, 03 Mar 2003 14:04:24 -0800
Message-ID: <F001.0055F024.20030303140424@fatcity.com>

For GUI, you can use VNC. Or "screen" utility. Both are freely avaible.

Or script it and nohup the job on Unix.

Richard Ji

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

Sent: Monday, March 03, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L

I ran into a problem yesterday afternoon. I had exported a production database, via a full database export, and ftp'd it to another machine to import it there and make that the new production machine. It was a long import (about 8 hours) and about 2/3 through it, my network connection was dropped. I was running it in a ssh shell. When the connection disappeared, the import died. Since I had to get the job done by morning, I chose to drop the database, rebuild it, then re-import. That worked.

What I am wondering is: Is there a way to resume an import, once it has been interrupted? I have been looking in metalink and on the net and haven't found anything that says how to do it. I tried technet, but it was way too slow. Any thoughts would be greatly appreciated.

Thank you,

--

Scott Canaan (srcdco_at_rit.edu)
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.

--

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

Author: Scott Canaan
INET: srcdco_at_ritvax.rit.edu

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

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

Author: Richard Ji
INET: richard.ji_at_mobilespring.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