tablespace is 92% used. [message #317743] |
Fri, 02 May 2008 23:58 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
liamadherne
Messages: 40 Registered: March 2008 Location: Philadelphia
|
Member |
|
|
Hello Eeverybody
While checking the free space in the DB, I came across one tablespace (AUDIT_TB) which is 92% used.
This tablespace contains one table(AUD$) and one index.
Is it safe to purge the mentioned table or index to make the tablespace usage below 90%.
Appreciate your view n this.
Thanks for your time.
Regards,
Liam.
|
|
|
|
Re: tablespace is 92% used. [message #317807 is a reply to message #317743] |
Sat, 03 May 2008 16:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
rlockard
Messages: 19 Registered: April 2008 Location: Baltimore, MD
|
Junior Member |
|
|
Before you purge sys.aud$ better check on policy. I always backup the table before cleaning it out.
This is your audit table and purging it could cost you your job. I fired one dba for cleaning out sys.aud$ without getting the customers blessing.
But can you purge sys.aud$? Yes you can. Do you really want to do it? Check with the owner of the data.
-Rob
|
|
|