Table and Tablespace

[Former Member]

Hi,

The SAP system is R/3 4.7 and database is oracle.

Can u please tell me the way to find out which table(sap table or 'z' table) belongs to which tablespace?

Please help.

Regards.

Siddhartha

[Former Member · Accepted solution]

Hi,

Go to db02 and click detailed analysis button.

Now enter table name in object field and press green right mark.

It will show the table and its corresponding table space.

[Former Member]

Hi,

Z-Tables are stored in PSAPUSER tablespace.

Regds,

Mani

[former_member227600]

Hi,

If i understand your question properly than you can find using DB02.

DB02>goto tablespace>select tablespace--->push tab/ind push button at top of ur right hand side .

After that you get a pop up window & you can fill object name(table/index) tablespace,object type & the size of object.

After that click on right sign u get your result

Karan