Skip to Main Content

Database Software

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!

aud$ table outside of SYSTEM tablespace

David Luis Moya GarridoJul 7 2015 — edited Jan 11 2016

It is habitual that periodically we find post about problems related to sys.aud$ table. Most of then are related to excessive growth of this table, you can truncate/shrink aud$ table, but you can't shrink SYSTEM tablespace...

To avoid space problems in SYSTEM tablespace, could be a good idea, that AUD$ table will residesĀ  out of SYSTEM tablespace ( in SYSAUX or in her own tablespace...). Today moving the table out of the SYSTEM tablespace is not supported.

My idea is to ask that aud$ table doesn't reside in system tablespace.

Regards-

Comments
Post Details
Added on Jul 7 2015
4 comments
1,793 views