Insert append nologging

Hi,

I have to insert a big table into another (9.2.0.4 ): insert /*+ append */ into T1 select * from from T2 nologging;

I have 2 questions:
- if T1 is empty, is /*+ append */ of any interest ?

• if the database is NOT in ARCHIVELOG, is nologging of any interest ?

Thanks for your help Received on Wed Feb 28 2007 - 02:21:50 CST