why not analyze the table and look at avg_row_len column on
user_tables?
joe
>>> ranganathk_at_subexgroup.com 06/19/01 04:30AM
>>>Dear DBA Gurus, I need to find the
size of one row of all the tables under a particularschema using vsize
clause. How do I do this? Please help.TIA and
Regards,Ranganath-- Please see the official ORACLE-L
FAQ: http://www.orafaq.com-- Author:
Ranganath K INET: ranganathk_at_subexgroup.comFat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051San
Diego, California -- Public Internet
access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).
Received on Tue Jun 19 2001 - 07:22:43 CDT
