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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 2 2016

Added on Nov 1 2016

#general-database-discussions

50 comments

8,065 views