Re: turn off transaction logging

carmine.natale_at_iqfinancial.com (Carmine) wrote in message news:<1eeb8b4.0302040747.6b0fe468_at_posting.google.com>...
> Can you turn off transaction logging in Oracle v8 or 9,
> in order to insert data from one table to another,
> and then turn transaction logging back on?

Hi,

  What I do in a situation like this is

  alter table my_table nologging;   

   ... to turn of logging for the table.

   and..

  alter index my_table_idx nologging;

  then do a direct path insert   

   insert /*+ APPEND */ into my_table select * from some_other_table.

This will turn off logging for operations that table, but not all logging.

Just be sure to do backup of the tables / indexes after you do this. Received on Tue Feb 04 2003 - 20:47:01 CET