Re: Import Problem

FYI... Even more useful than "screen" is "vnc" (www.tightvnc.com). It has some of the same capabilities as "screen", but it works like X-windows. Using VNC, you can start an Oracle Installer session on your laptop, shut it down, go home, and resume the session when you get where you are going. It is a complete life-saver for people who manage Oracle servers remotely, ever since the char-mode Oracle Installer vanished. For getting through DMZs and firewalls, it works with SSH2 "IP forwarding"...

...amazing stuff!

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, March 03, 2003 2:14 PM

> Scott,
>
> Try using screen. It is a piece of software using virtual tty 's.
>
> I began using it in 1994 to avoid just such problems.
>
> It gives you some unique capabilities. Start a process from
> one client, goto another client, detach and re-attach there.
>
> eg. start a job at home in a terminal window, goto work, and
> attach the screen there.
>
> And since it is running on the server itself, losing the network
> connection, your PC crashing, etc, does not interrupt your job.
>
> It is installed by default on some versions of Linux.
>
> http://www.gnu.org/directory/GNU/screen.html
>
> HTH
>
> Jared
>
>
>
>
>
>
> Scott Canaan <srcdco_at_ritvax.rit.edu>
> Sent by: root_at_fatcity.com
> 03/03/2003 09:08 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
> cc:
> Subject: Import Problem
>
>
> 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:
> INET: Jared.Still_at_radisys.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.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).