-
sppurge deletes SP data but Tablespace still full
(9.2)
I ran the $ORACLE_HOME/rdbms/admin/sppurge for more than 95% of the data stored in the STATSPACK tables. The used space in the associated tablespace did not go down at all. STATSPACK is the only tool code using this tablespace.
How do I free up the space in the tablespace? It is LMT.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|