Skip to Content
avatar image
Former Member

TST03 increasing table size

Hi All,

TST03 table size is now 1.2TB with oracle database 12c.

We have ECC EHP5 System.

RSPO/STORE_LOCATION IS DB

I want to retain/free the space occupied by TST03.

can you please suggest the right approach to perform this activity.

what all other ways I can perform with deleting old spool.

Thanks,

Satwraj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 01, 2017 at 02:49 PM

    For temse tables check the note 2388483 - How-To: Data Management for Technical Tables. Once you have done the cleanup of the table you may shrink the table as long as there are no LONG and LONG RAW fields. Check note 910389 - FAQ: Oracle Segment Shrinking.

    Add comment
    10|10000 characters needed characters exceeded