RE: Limit

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Mon, 19 Mar 2001 04:53:02 -0800
Message-ID: <F001.002D0665.20010319045026@fatcity.com>

You can have upto 32 columns to create one single Primary/Unique Key. Same no of columns can be used to create an index.

Some other limits are as follows:

Max Database Size : 512 Petabytes ( 1 Petabyte = 2 to the power 50) Max No of Tablespace ~= 2 Billion
Max No of Datafile per Tablespace = 1022 Max No of Partitions Per Table = 64000
Max no of columns per Table = 1000
Max size of BLOB,CLOB,NCLOB = 4GB

The list could be bigger and bigger ;-)))

HTH,
Rajesh

-----Original Message-----
Sent: Monday, March 19, 2001 4:11 PM
To: Multiple recipients of list ORACLE-L

Hello Gurus

I just want to know the number of columns that can be combined to make a primary key(composite).

I have a table with 16 columns of which I would like to make a combination 6
columns as a PK.

The volume of records may be 10,000 or less. This table will be used to generate a report(thro a screen).

Any suggestions on how to design the table

TIA Regards
Vishak

--

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

Author: Vishak
INET: vishak.holla_at_wipro.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

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

Author: Rajesh Dayal
INET: Rajesh_at_ohitelecom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------