Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Failure during a direct-path load - *NOT* a critical situation

Re: Failure during a direct-path load - *NOT* a critical situation

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 31 Mar 2002 11:08:34 -0800
Message-ID: <a87mri02irg@drn.newsguy.com>


In article <JMup8.100$FE4.8631592_at_newssvr17.news.prodigy.com>, "Simon says...
>
>Hello,
>I've been reading an old Oracle 7 book by Lynnwood Brown. He states that if
>a failure occurs during a direct-path load and the database is in
>noarchivelog mode, the db is then unrecoverable. Is that true? If it was
>true for 7, is it still true for 8 and 9? Simple yes or no answers will do
>but a more elaborate explanation is always welcome.
>Thank you for your help ahead of time,
>Simon Gottesman
>
>

it has never been true that a direct path load would render the database "unrecoverable".

The data loaded is unrecoverable but not the database. After a non-logged direct path load, you should backup the newly loaded data to protect it.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 
Received on Sun Mar 31 2002 - 13:08:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US