How to reduce the size of a tablespace and reclaim disk space

[Former Member]

Hello, we have recently deleted a number of clients in our QA system and have a tablespace PSAPABA702X that is 112GB (5 datafiles) that is only 0.6% used.

What do you suggest to reduce the size of the tablespace and reclaim the unused space. This will have the added benefit of reduced our backup time as well.

Thanks

Scott

[ashish_mishra2]

Hi

Looking at used %age of exchange tablespace, it is evident that some of the tables have left inside old exchange tablespace and therefore need migration from old exchange tabespace to new exchange tablespace. This happens due to bug in recently released SUM tool version which leaves some of the tables in old exchange tablespace.

You can get the list of tables remained in old tablespace using DB02 or below command from SQL level -

select TABLE_NAME, TABLESPACE_NAME from dba_tables where TABLESPACE_NAME='PSAPABA702X';

There are SAP notes to change the data class of leftover tables and then you can migrate those tables using brtools. Once tables are migrated, the used %age of PSAPABA702X will come down to 0% and post that you can drop tablespace using 'brspace -f tsdrop' command Online. No downtime required.

1819182 - Tables (TTREE*) remain in old exchange tablespace

2211218 - DDMTF_SAV and DDMTT_SAV tables remain in the old tablespace

Cheers!!!

Ashish

[Reagan]

PSAPABA702X appears to be an exchange tablespace which was created during an upgrade.

Check if there is another tablespace called PSAPABA702 and if yes you should move the contents of PSAPABA702X to PSAPABA702 and finally drop the tablespace PSAPABA702X.

[fidel_vales]

Hi,

Perhaps the esiest way is to move (with BRSPACE) whatever is left in tha tablespace (if anything) to another one and dropt it.

[Former Member]

Generally speaking: Read the friendly manual.

There is a lot of documentation available about a tablespace reorganisation.

No need to ask in a forum, imho.

That being said:

There are chances your tablespace PSAPABA702X isn't needed any more, and may be dropped.

How do you get that percentage of 0.6 ?

Are you sure there are actually any objects (tables, indexes, ...) in it?

Looks like a tablespace used for a previous release of your SAP system.

hope this helps.