Hi DBAs,
I was checking the nologging option for a table and noticed that flashback logging is happening for this table while inserting into the table with /*+APPEND */ hint.
Alter table <tablename> nologging;
insert /*+APPEND */ into <tablename> select * from dba_objects;
How it is possible to disable the flashback for a table while doing the data uploads without disabling flashback for the entire database.
Environment
Windows 2008 Server R2 64-bit
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
Thanks,
Salih KM