|
-
I think You do not need to recover the table in case if the table data is accidently deleted.
So, Set the table in NOLOGGING mode.
ALTER TABLE AUDIT_TABLE NOLOGGING.
This will ensure that the minimum redo/undo info is generated againt any DML on that table.
DELETE FROM AUDIT_TABLE
WHERE DT_COLUMN BETWEEN (starting date) and (Ending Date);
COMMIT;
This method is faster than any other method I foresee.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|