Nbre de champs en primary key ?

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
SQL> create table t( c1 number, c2 number, c3 number, c4 number, c5 number, c6 number, c7 number, c8 number, c9 number, c10 number, c11 number, c12 number, c13 number, c14 number, c15 number, c16 number, c17 number, c18 number, c19 number, c20 number, c21 number, c22 number, c23 number, c24 number, c25 number, c26 number, c27 number, c28 number, c29 number, c30 number, c31 number, c32 number, c33 number, c34 number);
 
Table created.
 
SQL> alter table t add primary key( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33,  c34);
 
ERROR at line 1:
ORA-02257: maximum number of columns exceeded
 
 
SQL> alter table t add primary key( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33);
 
Table altered.

cependant, la limite est de 32 colonnes (et non 33!!!)

http://download-uk.oracle.com/docs/c...h44.htm#288033

Citation:

Per index (or clustered index) 32 columns maximum