Database Administration (MOSC)

MOSC Banner

reorganize aud$ table

edited Oct 18, 2019 12:04PM in Database Administration (MOSC) 31 commentsAnswered ✓

Hello everyone dear friends, In the database, my aud $ field is constantly populating the system tablespace. I'm temporarily decoding it by adding a datafile, but I'd like to change it. I created a new tablespace and decided to move my aud $ table there. unfortunately my AUD $ table size is 120 GB. is there any suggestion? I was wondering if another problem would be the loss of service in the database while re-organizing the aud $ table, or did any problems occur? how long does it take on average? Should I truncate as a last resort?

Yours to all

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center