Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Max lenght of primary key ??

Max lenght of primary key ??

From: Bas Ven <ven_at_ats.nld.alcatel.nl>
Date: 1997/06/23
Message-ID: <33AE3922.12CE@ats.nld.alcatel.nl>#1/1

I was trying to create the following simple table:

CREATE TABLE physicalLink_table
(

neId     VARCHAR2(255),
elmId    VARCHAR2(255),	  	
portId   VARCHAR2(255),	  	
neB      VARCHAR2(255),
elmB     VARCHAR2(255),
portB    VARCHAR2(255),

CONSTRAINT pk_pl PRIMARY KEY ( neId, elmId, portId ) )
TABLESPACE userdata
STORAGE ( INITIAL 12K NEXT 12K ); and Oracle gives me the following error:

CREATE TABLE physicalLink_table
*
ERROR at line 1:
ORA-01450: maximum key length exceeded

In the documentation I could only find the restriction that the primary key can be made up out of a maximum of 16 columns. I could not find anything about the maximum size of the primary key. Can anyone shed some light on this?
(by the way: server version 7.1.4)

-- 
-----------------------------------------------------------------
J.B. Ven                              | Alcatel Telecom Nederland
Phone: +31 (70) 3079130               | P.O. Box 3292 
Fax:   +31 (70) 3079191               | NL-2280 GG  Rijswijk
Work:  mailto:ven_at_ats.nld.alcatel.nl  | The Netherlands
Home:  mailto:basven_at_xs4all.nl        |
-----------------------------------------------------------------
Received on Mon Jun 23 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US