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!

Is it safe to truncate SYS.AUD$

3018678Jan 8 2016 — edited Jan 8 2016

Hi All,

We have to close audit, it allocates too many sace. We have to truncate as soon as possible. So, is it safe to truncate SYS.AUD$ table? And should I truncate it in order to make space?

alter system set audit_trail='none' scope=spfile;

Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 5 2016

Added on Jan 8 2016

#general-database-discussions

7 comments

11,619 views