problemas con script de creacion de tablas

[qsflay]

hola, tengo el siguiente script:

Código:

CREATE TABLE  "ASIGNATURAS" 
   (	"CODIASIG" NUMBER NOT NULL ENABLE, 
	"NOM" VARCHAR2(4000) NOT NULL ENABLE, 
	 CONSTRAINT "ASIGNATURAS_PK" PRIMARY KEY ("CODIASIG") ENABLE
   )
/

CREATE OR REPLACE TRIGGER  "BI_ASIGNATURAS" 
  before insert on "ASIGNATURAS"               
  for each row  
begin   
select seq_assig.nextval into :NEW.CODIASIG from dual;
end; 
/
ALTER TRIGGER  "BI_ASIGNATURAS" ENABLE
/

CREATE OR REPLACE TRIGGER  "T_ASSIG" 
after delete on asignaturas
for each row
begin
delete from horari where codasig = :OLD.CODIASIG;
end;
/

ALTER TRIGGER  "T_ASSIG" ENABLE
/

CREATE OR REPLACE TRIGGER  "T_ELMASSIG" 
after delete on ASIGNATURAS
for each row
begin
delete from horari where codasig=:old.codiasig;
end;
/

ALTER TRIGGER  "T_ELMASSIG" ENABLE
/

CREATE TABLE  "AULA" 
   (	"IDAULA" NUMBER(3,0), 
	"NOMAULA" VARCHAR2(50), 
	"DESCRIP" VARCHAR2(150), 
	 CONSTRAINT "AULAPK" PRIMARY KEY ("IDAULA") ENABLE
   )
/

CREATE OR REPLACE TRIGGER  "T_ELAULA" 
after delete on aula
for each row
begin
delete from horari where idaula = :old.idaula;
end;
/

ALTER TRIGGER  "T_ELAULA" ENABLE
/

CREATE TABLE  "DEPARTAMENT" 
   (	"IDDEPT" NUMBER(4,0), 
	"NOMDEPT" VARCHAR2(100) NOT NULL ENABLE, 
	 CONSTRAINT "DEPTPK" PRIMARY KEY ("IDDEPT") ENABLE
   )
/

CREATE OR REPLACE TRIGGER  "T_ELMDEPT" 
after delete on departament
for each row
begin
update professor set iddept = null where iddept = :old.iddept;
end;
/

ALTER TRIGGER  "T_ELMDEPT" ENABLE
/

CREATE TABLE  "FALTAPROFE" 
   (	"IDPROFE" NUMBER(4,0), 
	"DATA" DATE, 
	"HORA" VARCHAR2(5), 
	"MOTIU" VARCHAR2(100), 
	"FEINA" VARCHAR2(500), 
	 CONSTRAINT "AUSENCIAPK" PRIMARY KEY ("IDPROFE", "DATA") ENABLE
   )
/

CREATE TABLE  "FALTES_PER_PROFES" 
   (	"ID_PROFE" NUMBER NOT NULL ENABLE, 
	"CONTAGUARD" NUMBER NOT NULL ENABLE, 
	 CONSTRAINT "FALTES_PER_PROFES_PK" PRIMARY KEY ("ID_PROFE") ENABLE
   )
/

CREATE TABLE  "GUARDIA" 
   (	"IDGUARDIA" NUMBER(10,0), 
	"IDPROFE" NUMBER(4,0), 
	"DIA" VARCHAR2(10) NOT NULL ENABLE, 
	"HORA" VARCHAR2(5), 
	 PRIMARY KEY ("IDGUARDIA") ENABLE, 
	 CONSTRAINT "GUARDIAFKPROF" FOREIGN KEY ("IDPROFE")
	  REFERENCES  "PROFESSOR" ("IDPROFE") ENABLE
   )
/

CREATE TABLE  "GUARDIAEFECTIVA" 
   (	"IDGUARDIA" NUMBER(10,0), 
	"DATA" DATE, 
	"PROFEACOBRIR" NUMBER(4,0), 
	"SIGNADA" VARCHAR2(1), 
	"TASQUES" VARCHAR2(100), 
	 CONSTRAINT "GEPK" PRIMARY KEY ("IDGUARDIA", "DATA") ENABLE, 
	 CONSTRAINT "GEFK1" FOREIGN KEY ("IDGUARDIA")
	  REFERENCES  "GUARDIA" ("IDGUARDIA") ENABLE, 
	 CONSTRAINT "GEFK3" FOREIGN KEY ("PROFEACOBRIR")
	  REFERENCES  "PROFESSOR" ("IDPROFE") ENABLE
   )
/

CREATE TABLE  "HORARI" 
   (	"CODASIG" NUMBER(5,0), 
	"DIA" VARCHAR2(10), 
	"HORA" VARCHAR2(5), 
	"IDPROFE" NUMBER(4,0), 
	"IDAULA" NUMBER(3,0), 
	 CONSTRAINT "HORARIPK" PRIMARY KEY ("CODASIG", "DIA", "HORA") ENABLE, 
	 CONSTRAINT "HORARIPKPROF" FOREIGN KEY ("IDPROFE")
	  REFERENCES  "PROFESSOR" ("IDPROFE") ENABLE, 
	 CONSTRAINT "HORARIPKAULA" FOREIGN KEY ("IDAULA")
	  REFERENCES  "AULA" ("IDAULA") ENABLE
   )
/


CREATE TABLE  "PROFESSOR" 
   (	"IDPROFE" NUMBER(4,0), 
	"NOM" VARCHAR2(50), 
	"COGNOMS" VARCHAR2(50), 
	"SIGNATURA" VARCHAR2(10), 
	"IDDEPT" NUMBER(3,0), 
	 CONSTRAINT "PROFESSORPK" PRIMARY KEY ("IDPROFE") ENABLE, 
	 FOREIGN KEY ("IDDEPT")
	  REFERENCES  "DEPARTAMENT" ("IDDEPT") ENABLE
   )
/

CREATE OR REPLACE TRIGGER  "T_PROFE" 
after delete on PROFESSOR
for each row
begin
delete from horari where idprofe=:old.idprofe;
delete from guardia where idprofe=:old.idprofe;
end;
/

ALTER TRIGGER  "T_PROFE" ENABLE
/

Al cargarlo y ejecutarlo, me da error al crear las tablas "guardia", "guardiaefectiva" y "horaris" diciendo: ORA-00942: la tabla o vista no existe

Si se ejecutan las sentencias que las crea por separado, no da error y si las crea,
Alguien me puede decir el porque pasa?

Gràcias

[huesos52]

Por el orden en el que se encuentra el script.

Fijate que la tabla professor el la ultima, sin embargo, las tablas que dices tienen fallos, requieren de esta tabla en sus constraints.

De seguro si pones la tabla professor al inicio el script te corre sin problemas.

saludos

[qsflay]

Gràcias, ha funcionado canviar el ordren de las tablas