Table name or groth

[Former Member]

Dear All,

My System Ecc6.0,with Oracle10g,I requard Table Information all tables name , data size groth and most use table nname pls help...

Regard's

vinod

[Former Member · Accepted solution]

Vinod,

You can check the table size by using tcode DB02OLD in 10g. DB02OLD>Detail analysis>Object name=-->Tablespace= >Object Type>table*

This wil show all the table. You can sort it to check all table which are large in size. Similary you can find Indexes as well & if you find Index size larger than table size you can rebuild those indexes to make some free space.

Also check below link.It may help you

Thanks

Sushil

[anindya_bose]

Hi Vinod

Check transaction ST10 and explore lots of information available there.

To see the table growth for a particular table go to tcode db02 or db02old and in the click on "detailed analysis" enter the table name in the Object field ( 'table_name") . You can see table and index stats for that table, Click on table name and then on history tab.

Thanks and Regards

Anindya

Edited by: Anindya Bose on Jun 30, 2009 1:35 PM