Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Failure during a direct-path load - *NOT* a critical situation
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 CorpReceived on Sun Mar 31 2002 - 13:08:34 CST