Re: Please Help : Maximum Length of an oracle record?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 03 Sep 1998 14:00:37 GMT
Message-ID: <3606a010.90242551@192.86.155.100>

A copy of this was sent to dmoharir_at_hotmail.com (if that email address didn't require changing) On Thu, 03 Sep 1998 13:20:03 GMT, you wrote:

>What is the maximum length of an oracle record ?!(in 7.3.x, 8.x)
>Which oracle manual mentions this ?
>

server reference manual has limits.

the max row width is a function of the datatypes and number of columns.

In 7.x

- max columns = 254
- max varchar2 width = 2000 bytes
- max longs/long raws per table = 1
- long/long width = 2gig

In 8.x

- max columns = 1000
- max varchar2 width = 4000 bytes
- max clobs/blobs per table = 1000
- clob/blob width = 4gig

So, in 7.x the widest row could be:

254*2000 = 508,000 bytes (~496Kbytes) OR 253*2000 + 2gig = 2gig + 506,000 bytes

In 8.x, the widest rows would be:
1000 * 4000 = 4,000,000 ( ~3.8Mbytes) OR 1000 * 4gig = 4,000 gig :)

>Thanks in Advance,
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Sep 03 1998 - 09:00:37 CDT