Re: Record Size

From: Andrew Mobbs <andrewm_at_chiark.greenend.org.uk>
Date: 18 Oct 2001 18:15:06 +0100 (BST)
Message-ID: <IBk*go88o@news.chiark.greenend.org.uk>

Phil Brooks <philbrooks_at_mn.mediaone.net> wrote:
>What is the maximum number of bytes allowed in a record? Are there limits on
>the number of fields within a record? Thanks.

It depends. Mostly it depends on the version of Oracle which you fail to mention. See the Oracle "Concepts" manual for the details in the version you intend to use. They're available online at http://technet.oracle.com/

Assuming 8i:
The amount of data in a single field depends on the datatype, the largest is a LOB, which can store 4GB
There is an implementation limit of 1023 columns in a table (IIRC).

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/

Received on Thu Oct 18 2001 - 12:15:06 CDT