Bonjour,

Je me tourne vers vous suite à deux problèmes rencontré sur un script de création de table.

Au niveau d'une table se nommant t_clients tout d'abord :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
REM ##########################################
REM ##### Création de la table t_clients #####
REM ##########################################
 
PROMPT ****** Création de la table t_clients...
 
CREATE TABLE t_clients (
		client_id NUMBER(6),
		nom VARCHAR2(25) CONSTRAINT c_nn_t_clients_nom NOT NULL,
		prenom VARCHAR2(25) CONSTRAINT c_nn_t_clients_prenom NOT NULL,
		adresse VARCHAR2(100),
		telephone VARCHAR2(20),
		sexe CHAR(1),
		date_naissance DATE CONSTRAINT c_nn_t_clients_date_naissance NOT NULL,
		abonnement_id NUMBER(6),
		date_abonnement DATE
		);
 
ALTER TABLE t_clients ADD (
		CONSTRAINT pk_t_clients PRIMARY KEY (client_id),
		CONSTRAINT fk_t_abonnements_t_clients FOREIGN KEY (abonnement_id) REFERENCES t_abonnements (abonnement_id)
		);
 
CREATE SEQUENCE seq_t_clients
INCREMENT BY 1
START WITH 1
NOCYCLE
NOCACHE;
 
Prompt ****** Insertion des données dans la table ...
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Eustache','Josias','31 du Chateau Landon - F-75010 Paris','01.31.31.31.31','H',TO_DATE('12/05/1980','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Geneix','Nicolas','32 du Chateau Landon - F-75010 Paris','01.32.32.32.32','H',TO_DATE('01/08/1982','DD/MM/YYYY'),'2','10/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Gheza','Gatien','33 du Chateau Landon - F-75010 Paris','01.33.33.33.33','H',TO_DATE('08/02/1984','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Gilliers','Stephane','34 du Chateau Landon - F-75010 Paris','01.34.34.34.34','H',TO_DATE('03/08/1980','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Girard','Loic','35 du Chateau Landon - F-75010 Paris','01.35.35.35.35','H',TO_DATE('12/02/1983','DD/MM/YYYY'),'1','23/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Godbert','Julien','36 du Chateau Landon - F-75010 Paris','01.36.36.36.36','H',TO_DATE('02/08/1983','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Goloubiatnikov','Mathieu','37 du Chateau Landon - F-75010 Paris','01.37.37.37.37','H',TO_DATE('20/10/1984','DD/MM/YYYY'),'3','14/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Grondin','Fabrice','38 du Chateau Landon - F-75010 Paris','01.38.38.38.38','H',TO_DATE('15/08/1984','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Guy-Faure','Fabien','39 du Chateau Landon - F-75010 Paris','01.39.39.39.39','H',TO_DATE('08/04/1984','DD/MM/YYYY'),'2','11/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Herdhuin','Cyrille','40 du Chateau Landon - F-75010 Paris','01.40.40.40.40','H',TO_DATE('07/06/1982','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Jacquand','Marc','42 du Chateau Landon - F-75010 Paris','01.42.42.42.42','H',TO_DATE('24/06/1981','DD/MM/YYYY'),'3','07/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Jiwa','Rahim','43 du Chateau Landon - F-75010 Paris','01.43.43.43.43','H',TO_DATE('10/08/1980','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Kaidi','Khireddine','44 du Chateau Landon - F-75010 Paris','01.44.44.44.44','H',TO_DATE('22/10/1981','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Krief','Jonathan','45 du Chateau Landon - F-75010 Paris','01.45.45.45.45','H',TO_DATE('14/06/1981','DD/MM/YYYY'),'1','02/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Labe','Hugues','46 du Chateau Landon - F-75010 Paris','01.46.46.46.46','H',TO_DATE('27/05/1982','DD/MM/YYYY'),'3','14/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Lachari','David','47 du Chateau Landon - F-75010 Paris','01.47.47.47.47','H',TO_DATE('23/05/1980','DD/MM/YYYY'),'2','08/08/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Languereau','Guillaume','48 du Chateau Landon - F-75010 Paris','01.48.48.48.48','H',TO_DATE('23/11/1982','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Lanouguere','Baptiste','49 du Chateau Landon - F-75010 Paris','01.49.49.49.49','H',TO_DATE('13/06/1984','DD/MM/YYYY'),'2','15/08/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Laplantif','Florian','50 du Chateau Landon - F-75010 Paris','01.50.50.50.50','H',TO_DATE('01/08/1980','DD/MM/YYYY'),'2','13/07/2004');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Lebosse','Guillaume','51 du Chateau Landon - F-75010 Paris','01.51.51.51.51','H',TO_DATE('23/11/1983','DD/MM/YYYY'),'3','12/08/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Leclere','Julien','52 du Chateau Landon - F-75010 Paris','01.52.52.52.52','H',TO_DATE('06/02/1982','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Lejet','Harold','53 du Chateau Landon - F-75010 Paris','01.53.53.53.53','H',TO_DATE('13/07/1983','DD/MM/YYYY'),'1','04/08/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Loyot','Guillaume','54 du Chateau Landon - F-75010 Paris','01.54.54.54.54','H',TO_DATE('03/10/1984','DD/MM/YYYY'),'3','01/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Luu-Huu','Thierry','55 du Chateau Landon - F-75010 Paris','01.55.55.55.55','H',TO_DATE('13/10/1980','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Martinazzo','Jean-Paul','56 du Chateau Landon - F-75010 Paris','01.56.56.56.56','H',TO_DATE('05/02/1984','DD/MM/YYYY'),'1','15/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Maugard','Gregory','57 du Chateau Landon - F-75010 Paris','01.57.57.57.57','H',TO_DATE('02/02/1984','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Mauron','Yannick','58 du Chateau Landon - F-75010 Paris','01.58.58.58.58','H',TO_DATE('07/05/1982','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Merniche','Amar','59 du Chateau Landon - F-75010 Paris','01.59.59.59.59','H',TO_DATE('13/05/1984','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Meunier','Axel','60 du Chateau Landon - F-75010 Paris','01.60.60.60.60','H',TO_DATE('03/01/1983','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Mitel','Fabrice','61 du Chateau Landon - F-75010 Paris','01.61.61.61.61','H',TO_DATE('14/02/1983','DD/MM/YYYY'),'2','15/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Naulot','Jean','62 du Chateau Landon - F-75010 Paris','01.62.62.62.62','H',TO_DATE('27/10/1980','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Ouahioune','Tarik','63 du Chateau Landon - F-75010 Paris','01.63.63.63.63','H',TO_DATE('25/01/1980','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Panchakaran','Kanthappapillai','64 du Chateau Landon - F-75010 Paris','01.64.64.64.64','H',TO_DATE('04/01/1984','DD/MM/YYYY'),'2','09/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Pires','Michel','65 du Chateau Landon - F-75010 Paris','01.65.65.65.65','H',TO_DATE('10/09/1982','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Poinas','Xavier','66 du Chateau Landon - F-75010 Paris','01.66.66.66.66','H',TO_DATE('21/08/1981','DD/MM/YYYY'),'2','21/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Pradel','Regis','67 du Chateau Landon - F-75010 Paris','01.67.67.67.67','H',TO_DATE('02/05/1981','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Riss','Vincent','68 du Chateau Landon - F-75010 Paris','01.68.68.68.68','H',TO_DATE('27/11/1982','DD/MM/YYYY'),'1','03/08/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Riviere','Ludovic','69 du Chateau Landon - F-75010 Paris','01.69.69.69.69','H',TO_DATE('16/09/1984','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Ropert','Francois','70 du Chateau Landon - F-75010 Paris','01.70.70.70.70','H',TO_DATE('11/06/1983','DD/MM/YYYY'),'3','11/08/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Rossignol','Eleonore','71 du Chateau Landon - F-75010 Paris','01.71.71.71.71','H',TO_DATE('03/06/1984','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Sanou','David','72 du Chateau Landon - F-75010 Paris','01.72.72.72.72','H',TO_DATE('19/09/1980','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Soldati','Dorian','73 du Chateau Landon - F-75010 Paris','01.73.73.73.73','H',TO_DATE('05/04/1984','DD/MM/YYYY'),'2','02/08/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Tall','Abdoulaye','74 du Chateau Landon - F-75010 Paris','01.74.74.74.74','H',TO_DATE('09/08/1983','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Thuillier','Romain','75 du Chateau Landon - F-75010 Paris','01.75.75.75.75','H',TO_DATE('07/10/1984','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Tranchant','Jean-Baptiste','76 du Chateau Landon - F-75010 Paris','01.76.76.76.76','H',TO_DATE('04/10/1982','DD/MM/YYYY'),'1','24/07/2004');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Trang','William','77 du Chateau Landon - F-75010 Paris','01.77.77.77.77','H',TO_DATE('03/04/1983','DD/MM/YYYY'),'3','16/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Turken','Fatih','78 du Chateau Landon - F-75010 Paris','01.78.78.78.78','H',TO_DATE('24/10/1984','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Zachayus','Aurelien','79 du Chateau Landon - F-75010 Paris','01.79.79.79.79','H',TO_DATE('06/01/1980','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Zini','Alexandra','80 du Chateau Landon - F-75010 Paris','01.80.80.80.80','H',TO_DATE('21/10/1982','DD/MM/YYYY'),'1','04/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Zwang','Arnaud','81 du Chateau Landon - F-75010 Paris','01.81.81.81.81','H',TO_DATE('11/06/1984','DD/MM/YYYY'),'NULL','NULL');
Je me retrouve avec l'erreur suivante :

****** Insertion des données dans la table ...
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Eustache','Josias','31 du Chateau Landon - F-75

ERREUR à la ligne 1 :
ORA-01722: invalid number
Ensuite au niveau de trois tables t_billets t_reservations et t_employees.
Je ne vous affiche que la table t_billets

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
REM ##########################################
REM ##### Création de la table t_billets #####
REM ##########################################
 
PROMPT ****** Création de la table t_billets...
 
CREATE TABLE t_billets (
		billet_id NUMBER(6),
		siege NUMBER(3) CONSTRAINT c_nn_t_billets_siege NOT NULL,
		client_id NUMBER(6) CONSTRAINT c_nn_t_billets_client_id NOT NULL,	  
		wag_tr_id NUMBER(6) CONSTRAINT c_nn_t_billets_wag_tr_id NOT NULL,
		reservation_id NUMBER(6) CONSTRAINT c_nn_t_billets_reservation_id NOT NULL,
		type VARCHAR2(10) CONSTRAINT c_nn_t_billets_type NOT NULL
		);
 
ALTER TABLE t_billets ADD (
		CONSTRAINT pk_t_billets PRIMARY KEY (billet_id),
		CONSTRAINT fk_t_clients_t_billets_1 FOREIGN KEY (client_id) REFERENCES t_clients (client_id),
		CONSTRAINT fk_t_reserv_t_billets_2 FOREIGN KEY (reservation_id) REFERENCES t_reservations (reservation_id),
		CONSTRAINT fk_t_wagons_trains_t_billets_3 FOREIGN KEY (wag_tr_id) REFERENCES t_wagons_trains (wag_tr_id)
		);
 
CREATE SEQUENCE seq_t_billets
INCREMENT BY 1
START WITH 1
NOCYCLE
NOCACHE;
 
Prompt ****** Insertion des données dans la table ...
INSERT INTO t_billets VALUES (seq_t_billets.nextval,10,43,122,15,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,16,47,118,15,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,17,47,122,15,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,10,18,24,16,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,3,33,84,17,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,10,33,88,17,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,8,43,115,18,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,13,43,116,18,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,14,53,114,18,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,6,53,116,18,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,14,66,133,19,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,16,59,2,20,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,4,30,22,21,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,6,39,44,22,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,9,46,62,23,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,10,46,63,23,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,17,75,78,23,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,15,53,97,24,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,2,33,98,25,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,3,45,105,26,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,14,52,126,27,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,7,52,127,27,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,13,59,1,28,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,14,59,5,28,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,7,37,94,29,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,7,41,3,30,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,18,41,7,30,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,3,41,53,30,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,10,41,55,30,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,16,50,1,31,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,8,50,8,31,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,8,72,13,31,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,17,72,17,31,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,17,34,37,32,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,14,39,134,33,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,18,69,10,34,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,16,69,16,34,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,16,15,33,35,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,13,27,59,36,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,15,54,8,37,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,19,77,8,38,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,17,49,12,39,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,15,49,17,39,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,12,68,127,40,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,6,66,130,41,'Aller');
Je me retrouve avec l'erreur suivante :

INSERT INTO t_billets VALUES (seq_t_billets.nextval,6,66,130,41,'Aller')
*
ERREUR à la ligne 1 :
ORA-02291: integrity constraint (PAR_PS1_05.FK_T_RESERV_T_BILLETS_2) violated -
parent key not found
Pour ce qui est de la première erreur, je n'ai pas d'idée.
Pour ce qui est de la seconde, on m'a conseillé de desactiver les contraintes de clés étrangères ce que j'ai fait via le script trouvé ici : http://oracle.developpez.com/sources...active_fk_user

Mais malgès cela, ça ne fonctionne toujours pas.

J'espère que quelqu'un saura m'expliquer d'ou provient le problème et eventuellement comment le resoudre assez rapidement, etant donné que la deadline de rendu de la base approche à très grand pas (mercredi)

Je vous met ici une copie du script entier au cas ou vous auriez besoin d'information complémentaire : http://membres.lycos.fr/forumlv/tables.sql

Merci d'avance pour votre aide.