-
Hi,
How shall we find out the size of the tables?
We know to find out the size of the tablespace, could any one tell me thesyntax?
Thanks in advance,
bye
gandhi
-
Maybe the DBA_SEGMENTS view will help. There is a column name BYTES.
-
if i am able to undersatnd your question right and what you wanted is the amount of space that is alocated to a table then just use the following query.
SELECT SEGMENT_NAME,SUM(BYTES)
FROM DBA_SEGMENTS
WHERE SEGMENT_TYPE='TABLE'
GROUP BY SEGMENT_NAME
hth
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|