Discussion :

[boutte]

bonjour,
je suis en 9i, y a t'il un nombre limite de champs que l'on peut mettre en définition de sa clé primaire sur sa table ?

Merci

[laurentschneider]

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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

Per index (or clustered index) 32 columns maximum