Rachel, Did you ever determine if the unix "crossmount" or such to be the complete problem....? Did the Rman backup turn out to be ok after all- no corruptions?
Ever find out if they run validate command? Thanks Rachel, Brian Spears -----Original Message----- Sent: Monday, March 03, 2003 1:24 PM To: Multiple recipients of list ORACLE-L now you know why I script everything and run it as a background job on the database server itself. :) That I know of, there is no way to restart an import... unless you have primary key or unique constraints on all objects and you are will to do "ignore=y" so that you get constraint errors on every existing row but do load all the remaining ones. There isn't anything "clean" that I know of though. Sorry --- Scott Canaan <[EMAIL PROTECTED]> wrote: > 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 ([EMAIL PROTECTED]) > (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: [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). > __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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: Spears, Brian 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).