Finding largest tables in Oracle 12c database

[danielsapbasis]

Hi Experts,

I need to find the largest tables list for performing table splitting in SWPM source export.

I dont see navigation for it in DBACOCKPIT and DB02 transaction codes. I see only tablespace's information

Please guide me.

Thanks in advance

[S_Sriram · Accepted solution]

Hi Daniel,

Check this SCN thread

https://blogs.sap.com/2014/08/05/easy-way-to-check-the-biggest-tables-in-sap/#:~:text=I%20would%20li....

Regards

SS

[mamartins]

You need to go to option "Detailed Analysis" of "Objects" on the "Space" tab and filter by type TABLE.

[vamsi9710]

In filters select TYPE as a TABLE