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!

Can I disable logging for session in Oracle 10g?

548150Jul 23 2009 — edited Jul 25 2009

I use a procedure to delete a lot of row for an application repeatedly. Because the DELETE statement is time consuming and the data don't need to be archived, I decide to use the nologging option.
How to do it?
What is the best choice? Can I disable logging from session in Oracle 10g?

Thank you

Edited by: jetq on Jul 23, 2009 9:46 AM

This post has been answered by SomeoneElse on Jul 23 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 22 2009

Added on Jul 23 2009

#general-database-discussions

22 comments

4,300 views