Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

reduce flashback log - disable flashback for a table

506098Apr 24 2007 — edited Apr 24 2007

Hi,

We have a table which we use only for logging. This information is not essential but there is a lot (given our scale of data :p ) of data (5.000.000 by day)

So we have put the table in nologging (reduce redo => archived),
the insert are /*+ append*/ (reduce undo)

Now, we want to reduce the flashback logs?

Is there a way to disable flashback for a given table ?

thanks

Nicolas

Locked Post

New comments cannot be posted to this locked post.

Locked on May 22 2007

Added on Apr 24 2007

#general-database-discussions

3 comments

395 views