From oracle-l-bounce@freelists.org  Thu Dec 16 15:08:43 2004
Return-Path: <oracle-l-bounce@freelists.org>
Received: from air189.startdedicated.com (root@localhost)
 by orafaq.com (8.11.6/8.11.6) with ESMTP id iBGL8Vm25790
 for <oracle-l@orafaq.com>; Thu, 16 Dec 2004 15:08:37 -0600
X-ClientAddr: 206.53.239.180
Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180])
 by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iBGL8LN25749
 for <oracle-l@orafaq.com>; Thu, 16 Dec 2004 15:08:31 -0600
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4568B72CAFF;
 Thu, 16 Dec 2004 16:14:48 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP
 id 10129-12; Thu, 16 Dec 2004 16:14:48 -0500 (EST)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4ED8F72C818;
 Thu, 16 Dec 2004 16:11:56 -0500 (EST)
X-VirusChecked: Checked
X-Env-Sender: roger_xu@dp7uptx.com
X-Msg-Ref: server-6.tower-65.messagelabs.com!1103231190!20714537!5
X-StarScan-Version: 5.4.2; banners=dp7uptx.com,-,-
X-Originating-IP: [216.136.17.254]
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0
Subject: RE: how to find max_row_size ?
Date: Thu, 16 Dec 2004 15:06:12 -0600
Message-ID: <A6801E8A03316A4DA597866F77A013F7059C9169@irv2kexch01>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: how to find max_row_size ?
Thread-Index: AcTjsE+4U2wh6iiUQ1S7gxOEeA1j7AAApvdQ
From: "Roger Xu" <roger_xu@dp7uptx.com>
To: <oracledbam@hotmail.com>, <oracle-l@freelists.org>
X-archive-position: 13817
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-To: oracle-l-bounce@freelists.org
X-original-sender: roger_xu@dp7uptx.com
Precedence: normal
Reply-To: roger_xu@dp7uptx.com
X-list: oracle-l
X-Virus-Scanned: by amavisd-new at freelists.org

select=20column_name,data_length
from=20dba_tables=20a,=20dba_tab_columns=20b
where=20a.owner=20=3D=20'OWNERNAME'
=20=20and=20a.table_name=20=3D=20'TABLENAME'
=20=20and=20a.table_name=20=3D=20b.table_name

-----Original=20Message-----
From:=20Seema=20Singh=20[mailto:oracledbam@hotmail.com]
Sent:=20Thursday,=20December=2016,=202004=202:34=20PM
To:=20oracle-l@freelists.org
Subject:=20how=20to=20find=20max_row_size=20?


Hi,
how=20to=20find=20max_row_size=20of=20table?
thanks


--
http://www.freelists.org/webpage/oracle-l

For=20technical=20support=20please=20email=20tech_support@dp7uptx.com=20or=
=20you=20can
call=20(972)721-8257.=20
This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes=
sageLabs=20Email=20Security=20System.

This=20e-mail=20is=20intended=20solely=20for=20the=20person=20or=20entity=20=
to=20which=20it=20is=20addressed=20and=20may=20contain=20confidential=20an=
d/or=20privileged=20information.=20Any=20review,=20dissemination,=20copyin=
g,=20printing=20or=20other=20use=20of=20this=20e-mail=20by=20persons=20or=20=
entities=20other=20than=20the=20addressee=20is=20prohibited.=20If=20you=20=
have=20received=20this=20e-mail=20in=20error,=20please=20contact=20the=20s=
ender=20immediately=20and=20delete=20the=20material.=20
____________________________________________________________________
This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes=
sageLabs=20Email=20Security=20System.=20Any=20questions=20please=20call=20=
972-721-8257=20or=20email=20your=20request=20to=20tech_support@dp7uptx.com=
.
--
http://www.freelists.org/webpage/oracle-l

