List of tables in a tablespace

[Former Member]

Hi,

I would like to know which transaction (or equivalent in SAP level) allows me to get the list of tables in a tablespace.

I checked in DB02/detailed analysis but nothing.

Thanks

Amin

[Former Member · Accepted solution]

Hi,

Please find the below steps.

Tcode DB02OLd -> click on Detailed Analysis and use the tablespace in criteria.

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

Hi Orkun,

    in DB02 it not possible.. however if you use the tcode DB02old tcode you should be able to get the information.

1. Tcode DB02OLD

2. Click on detailed analysis under tables and indexes section.

3.enter the name of the tablespsace you wish to see the list of tables.

4.Rest mark as *

5. click on tick button...

You can get the list of tables with sizes ...

I hope the information helps.

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

Hi Vimalan,

>>  in DB02 it not possible.. however if you use the tcode DB02old tcode you should be able to get the information.

No, it is not correct. You can access the the tables from "DB02 -> Space -> Segments -> Detailed Analysis" too.

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

Hi Orkun,

Sorry. Instead of possible, i have added NOT before.

Thanks for correcting me 🙂

Thanks and Regards,

Vimal

[Former Member]

Hi Amin,

>> I checked in DB02/detailed analysis but nothing.

It is weird. Check the related OSS notes. Alternatively you can execute the query to get answer;

SQL> select tablespace_name from dba_segments where segment_name in ('<tablename>');

Best regards,

Orkun Gedik