DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Keene, NH

    sppurge deletes SP data but Tablespace still full

    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.

  2. #2
    Join Date
    Dec 2002
    Munich, Germany
    If you take a look into sppurge.sql script you can see that "delete" command used. Therefore hwm does't move and storage still allocated. If you really want to deallocate storage - use sptrunc.sql instead. But that will drop 100% statistics data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.