Nologging another question

From: Eric Fang <eric_fang_at_yahoo.com>
Date: Fri, 2 Jun 2000 17:48:06 -0700 (PDT)
Message-Id: <10516.107630@fatcity.com>

I create table with nologging,
use direct insert as :
insert into tablle1 select * from table2;

Q1: What happen if the application(which issue the statement) or the database crashed in the middle? Q2: If the insert finished sucessfully, also commited. Do we have to do a backup, otherwise those part of the data(of table1) will not be recovered. Is that right?

Thanks.

Eric Fang

---

Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
http://photos.yahoo.com Received on Fri Jun 02 2000 - 19:48:06 CDT