How to find which tables resides in a certain tablespace

[Former Member]

Hi experts, how can I figure it out which sap tables related to a certain tablespace?

[Former Member · Accepted solution]

Hi MrWhilte,

If you have access to database it can easily be checked by the following query on sql prompt.

" select TABLE_NAME from DBA_TABLES where TABLESPACE_NAME = '<Name of Tablespace>';"

Regards,

Vinit Pagaria

[Former Member]

Thanks

[Former Member]

Hi

go to DB02 or DB02old (depending on your release.. ) Detailed Analysis => type in tablespace name in leave everything else *

Mark