Oracle-L: Re: Import Problem

From: Ron Thomas <rthomas_at_hypercom.com>
Date: Mon, 03 Mar 2003 13:59:36 -0800
Message-ID: <F001.0055F008.20030303135936@fatcity.com>

If all you need is tty (character based), then screen should work. If you need a full GUI environment, then check out vnc. I use this alot for those 5 hour Oracle Application Installs.

Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
Each new user of a new system uncovers a new class of bugs. -- Kernighan

                                                                                                                                                 
                      Jared.Still_at_radis                                                                                                          
                      ys.com                   To:       ORACLE-L_at_fatcity.com                                                                    
                      Sent by:                 cc:                                                                                               
                      root_at_fatcity.com         Subject:  Re: Import Problem                                                                      
                                                                                                                                                 
                                                                                                                                                 
                      03/03/2003 02:14                                                                                                           
                      PM                                                                                                                         
                      Please respond to                                                                                                          
                      ORACLE-L

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

--

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

Author: Ron Thomas
INET: rthomas_at_hypercom.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