| tablespace is 92% used. [message #317743] |
Fri, 02 May 2008 23:58  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
