on 03-06-2009 6:16 AM
Hi,
How I can find exact table size.
Oracle 10G and ECC 6.0.
Thanks in advance.
Regards,
Rahul.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Rahul,
Go to T-Code DB02,it will give you all the details
Rohit
Thanks.
From db02 i will get total tble size but i need exact table oocupied size. Kindly help.
If you are trying to find table size for any particular table...
just a thought , Why don't you try from Oracle level....
select sum(BYTES/1024/1024) as TOTAL_GIG from user_segments where
SEGMENT_NAME = 'TABLE_NAME';
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.