ninad shah

• Jun 29th, 2007

 

You  can set primary key on table upto 16 columns of table in oracle 9i and 10g

Subashpanda

 Profile Answers by Subashpanda Questions by Subashpanda

• Dec 17th, 2010

 

The maximum number of columns that can be a part of Primary key in a table in Oracle 10g is 32.

nirmal1in

 Profile Answers by nirmal1in Questions by nirmal1in

• Dec 25th, 2010

 

Upto 33 columns can be added as part of primary key on 9i

Below create statement can be run successfully on 9i

create table t3(n1 number,n2 number,n3 number,n4 number,n5 number,n6 number,n7 number,n8 number,n9 number,n10 number,n11 number,n12 number,n13 number,n14 number,n15 number,n16 number,n17 number,n18 number,n19 number,n20 number,n21 number,n22 number,n23 number,n24 number,n25 number,n26 number,n27 number,n28 number,n29 number,n30 number,n31 number,n32 number,n33 number,n34 number,n35 number,
constraint pk3 primary key (n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,n13,n14,n15,n16,n17,n18,n19,n20,n21,n22,n23,n24,n25,n26,n27,n28,n29,n30,n31,n32,n33));

venkat

• Aug 26th, 2011

 

The maximum number of columns can be part of Primary Key in a table in Oracle 9i and 10g are 32

VENKAT

• Aug 26th, 2011

 

32

Sam

• Jul 25th, 2015

 

Is it possible to make composite primary key more than 32 column?

farida

• Aug 28th, 2015

 

32

Manoj Yadav

• Dec 8th, 2015

 

32

Somesh Menaria

 Profile Answers by Somesh Menaria 

• Feb 22nd, 2016

 

Server process write data from datafiles to buffer cache

Shubham

• Oct 7th, 2016

 

No,
We can not give more then 32 column primary key