Re: Maximum row length in bytes (9.2.0.5)

  • From: "biti_rainy" <biti_rainy@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 22 Apr 2004 18:18:31 +0800

hi,Stefan Jahnke

  do not use  lobs , one  table may have 1000 columns , varchar2=
 ,4000*1000 =3D 4000000 bytes ?

Best regards

yahoo id: feng_chunpei
A new dba from china

---- from the  mail-----
>Hi list
>
>Maybe I'm blind, but I couldn't find any information on the size=
 limit =3D
>of a single row. Does anybody know to what maximum number of=
 bytes a row =3D
>can grow in length? Does the usage of "inline" (B|C)LOBs effect=
 that =3D
>limit somehow?
>
>TIA,
>Stefan
>----------------------------------------------------------------=

>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------=

>To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at //www.freelists.org/archives/oracle-l/
>FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
>----------------------------------------------------------------=
-
>
>.


=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: