Skip to Main Content

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!

How to generate no Logs while deleting rows from table

KalpataruNov 1 2016 — edited Nov 4 2016

Hi All,

Oracle Database version : 11.2.0.4.0.

I have a table with 20 Gb of data.

I want to delete 90% of data let's say 18 gb data from the table with DELETE command with some condition.

Requirement is that i don't want to generate any logs like redo or any type of log while/after deleting.

I also don't want to revert rows back.

I also want to check the log is generated or not.

Please suggest the commands and Select queries checking the logs.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2016
Added on Nov 1 2016
50 comments
8,055 views