PSAPR3 -> What is inside of this tablespace?

[Former Member]

Hi all,

I would like to know what kind of information is inside the tablespace PSAPR3.

It will perfect some links, or documentation to know more about this topic.

Best Regards,

Erick Ilarraza

[Former Member · Accepted solution]

select TABLE_NAME from dba_tables where TABLESPACE_NAME='PSAPR3';

select INDEX_NAME from dba_indexes where TABLESPACE_NAME='PSAPR3';

or like that

select SEGMENT_NAME,SEGMENT_TYPE from dba_segments where TABLESPACE_NAME='PSAPR3';

[stefan_koehler]

Hello Erick,

your question is a little bit unexact, but if you want to know which tables are stored in a tablespace you can use the query from Baran.

If you want to know which kind of table / data class is stored in which tablespace (or especially in PSAPR3) you have to take a look at the following tables:

- TAORA (Mapping for kind of table/ data class and tablespace)

- IAORA (Mapping for kind of index / data class and tablespace)

For more information you can have a look at sapnote #46272, which describes how you can modify/add the mapping.

Regards

Stefan

[Former Member]

Hi All,

thanks a lot for your usefull answers.

Best Regards,

Erick Ilarraza

[Former Member]

Check this

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3204a72f-0d01-0010-db84-e2335f93...

regards

tamilboy