Skip to Content
0

TST03 increasing table size

Aug 01, 2017 at 12:09 PM

65

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Reagan Benjamin
Aug 01, 2017 at 02:49 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank You Reagan Benjamin!!

Will look into it and update here on the same.

0