From JTESTA@longaberger.com Tue, 19 Jun 2001 05:22:43 -0700 From: "JOE TESTA" Date: Tue, 19 Jun 2001 05:22:43 -0700 Subject: Re: How to find the size of all the tables under a particular Message-ID: MIME-Version: 1.0 Content-Type: text/plain why not analyze the table and look at avg_row_len column on user_tables?   joe   >>> ranganathk@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@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@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).