U cannot avoid generating redo for Inserts ...

But for this Kind of Insert u can use the append Key Word Like this..

insert /*+ Append */ into <tab_name> select * from <tab_name>@db_link;


But be aware that u dont have any triggers or References. Also Use this only
wheen u'r loading a Large number of tables.


HTH

Best Regards,
Ganesh R
Tel : +971 (4) 397 337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 7456019


-----Original Message-----
From: Ravindra, Babupochampally (CAP, GCF)
[mailto:Ravindra.[Email Address Removed] Saturday, December 29, 2001 10:34 AM
To: LazyDBA.com Discussion
Subject: Create table as nologging


Hi Gurus,

I have a doubt regarding nologging state of the table.

If I create a table as
create table <tab_name> as select * from <tab_name>@db_link nologging
i know the redologs are not generated for this.

But if we first create a table as
create table <tab_name> as select * from <tab_name>@db_link where 1=2
nologging;

and then insert the records later as
insert into <tab_name> select * from <tab_name>@db_link;

will this redologs get generated or not?how to avoid redologs getting
generated with this method.....

I hope i am clear......

Thanks,
Ravi


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page