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!

audit trail purging

user12983407Dec 11 2015 — edited Dec 11 2015

current oracle version : 11.2.0.4

aud$ has 90 million records. want to keep last 3 months records and purge/delete rest of the records.

I tried to inserting last 3 months records into separate table.. but this operation still running after 12 hours.

what is fastest to way to fulfilled the above requirement. ?

thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 8 2016

Added on Dec 11 2015

#general-database-discussions

5 comments

1,647 views