| row size [message #51457] |
Thu, 23 May 2002 11:22  |
K. Prakash babu
Messages: 46
Registered: July 2001
|
Member |
|
|
Hi
I hv 20 tables in my database. I need to find out the size of tables. How can i caluculate all the tablesizes? Shall anybody help me in this regard..pls.
|
|
|
|
| Re: row size [message #51458 is a reply to message #51457] |
Thu, 23 May 2002 11:38  |
Jyothi
Messages: 12
Registered: May 2002
|
Junior Member |
|
|
Hey prakash,
there are couple of diffrent ways by which you can find out the table size,
one of these is just query the dba_segments for the bytes and give segment_name to be the name of your table.
Hope that helps
|
|
|
|
| Re: row size [message #51470 is a reply to message #51457] |
Fri, 24 May 2002 00:55 |
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
|
Senior Member |
|
|
SIR,
PLEASE EXECUTE THE QUERY.
ANSWER WILL BE IN MB.
SELECT (BYTE/1024000) FROM DBA_SEGEMENTS WHERE SEGEMENT_NAME='EMP' (HERE EMP IS THE SEGMENT NAME FOR THE TALBE EMP.HERE GIVE YOUR SEGEMENT NAME(IT IS ALMOST YOUR TABLE NAME)
K.SREENIVASAN
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
