Thank you,
That's as I thought.
- Simon
"Thomas Kyte" <tkyte_at_oracle.com> wrote in message
news:a87mri02irg_at_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 - 21:42:04 CST
