Re: help required regarding on data insertions

Why do you want to give up recoverability? Jim
"Denis Doulat" <denis_at_starcomsoftware.com> wrote in message news: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 - 22:33:49 CET