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.