Home -> Usenet -> comp.databases.oracle -> help required regarding on data insertions

help required regarding on data insertions

From: Denis Doulat <denis_at_starcomsoftware.com>
Date: 8 Dec 2001 01:57:35 -0800
Message-ID: <9e7ec60.0112080157.3a5dd35f_at_posting.google.com> 






Hello,



        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.
Received on Sat Dec 08 2001 - 10:57:35 CET












Original text of this message