Can anyone please let me know that if there is a method of inserting
/ updateding/ deleting data from a table created using nologging
option without getting the DML entries logged into the redo log in an
archived log database mode.
example:
Database Mode - Archive Log Mode.
Table Created - NoLogging Mode.
a> If I use direct inserts then i can specify nologging and entries
are not logged to archive log.
b> If I had to do normal DML on the same table, how it would be
possible to do the same w/o causing redo logs being generated.
Also, temporary tables are out of question due to data visibility
issues across multiple sessions.
Thanks And Regards In Advance,
Denis.