Table INFORMACIE_O_CLOVEKU dropped.

Table MAJITEL dropped.

Table ZAMESTNANEC dropped.

Error starting at line : 4 in command -
DROP TABLE titul CASCADE CONSTRAINTS
Error report -
SQL Error: ORA-00942: tabuľka alebo pohľad neexistuje
00942. 00000 -  "table or view does not exist"
*Cause:
*Action:
Error starting at line : 5 in command -
DROP TABLE profesia CASCADE CONSTRAINTS
Error report -
SQL Error: ORA-00942: tabuľka alebo pohľad neexistuje
00942. 00000 -  "table or view does not exist"
*Cause:
*Action:
Error starting at line : 6 in command -
DROP TABLE druh_zvierata CASCADE CONSTRAINTS
Error report -
SQL Error: ORA-00942: tabuľka alebo pohľad neexistuje
00942. 00000 -  "table or view does not exist"
*Cause:
*Action:
Table ZVIERA dropped.

Error starting at line : 8 in command -
DROP TABLE ucinna_latka CASCADE CONSTRAINTS
Error report -
SQL Error: ORA-00942: tabuľka alebo pohľad neexistuje
00942. 00000 -  "table or view does not exist"
*Cause:
*Action:
Error starting at line : 9 in command -
DROP TABLE liek CASCADE CONSTRAINTS
Error report -
SQL Error: ORA-00942: tabuľka alebo pohľad neexistuje
00942. 00000 -  "table or view does not exist"
*Cause:
*Action:
Error starting at line : 10 in command -
DROP TABLE kotraindikacia CASCADE CONSTRAINTS
Error report -
SQL Error: ORA-00942: tabuľka alebo pohľad neexistuje
00942. 00000 -  "table or view does not exist"
*Cause:
*Action:
Table LIECBA dropped.

Table DOPORUCENE_DAVKOVANIE dropped.

Table DAVKOVANIE dropped.

Table DIAGNOZA dropped.

Table LIECBA_DAVKOVANIE_LIEK dropped.

Error starting at line : 16 in command -
DROP TABLE liek_diagnoza_doporucene_druh CASCADE CONSTRAINTS
Error report -
SQL Error: ORA-00942: tabuľka alebo pohľad neexistuje
00942. 00000 -  "table or view does not exist"
*Cause:
*Action:
Table INFORMACIE_O_CLOVEKU created.

Table MAJITEL created.

Table ZAMESTNANEC created.

Error starting at line : 41 in command -
CREATE TABLE titul(
  nazov VARCHAR2(30) NOT NULL UNIQUE PRIMARY KEY
)
Error report -
SQL Error: ORA-02259: duplicitné UNIQUE/PRIMARY KEY špecifikácie
02259. 00000 -  "duplicate UNIQUE/PRIMARY KEY specifications"
*Cause:    Self-evident.
*Action:   Remove the duplicate specification.
Error starting at line : 44 in command -
CREATE TABLE profesia(
  nazov VARCHAR2(30) NOT NULL UNIQUE PRIMARY KEY
)
Error report -
SQL Error: ORA-02259: duplicitné UNIQUE/PRIMARY KEY špecifikácie
02259. 00000 -  "duplicate UNIQUE/PRIMARY KEY specifications"
*Cause:    Self-evident.
*Action:   Remove the duplicate specification.
Error starting at line : 47 in command -
CREATE TABLE druh_zvierata(
  nazov VARCHAR2(30) NOT NULL UNIQUE PRIMARY KEY

)
Error report -
SQL Error: ORA-02259: duplicitné UNIQUE/PRIMARY KEY špecifikácie
02259. 00000 -  "duplicate UNIQUE/PRIMARY KEY specifications"
*Cause:    Self-evident.
*Action:   Remove the duplicate specification.
Table ZVIERA created.

Error starting at line : 61 in command -
CREATE TABLE ucinna_latka(
  nazov VARCHAR2(30) NOT NULL UNIQUE PRIMARY KEY

)
Error report -
SQL Error: ORA-02259: duplicitné UNIQUE/PRIMARY KEY špecifikácie
02259. 00000 -  "duplicate UNIQUE/PRIMARY KEY specifications"
*Cause:    Self-evident.
*Action:   Remove the duplicate specification.
Error starting at line : 65 in command -
CREATE TABLE liek(
  nazov VARCHAR2(30) NOT NULL UNIQUE PRIMARY KEY,

  nazov_ucinna_latka VARCHAR2(30) NOT NULL UNIQUE,
  nazov_kontraindikace VARCHAR2(30) NOT NULL UNIQUE
)
Error report -
SQL Error: ORA-02259: duplicitné UNIQUE/PRIMARY KEY špecifikácie
02259. 00000 -  "duplicate UNIQUE/PRIMARY KEY specifications"
*Cause:    Self-evident.
*Action:   Remove the duplicate specification.
Error starting at line : 71 in command -
CREATE TABLE kotraindikacia(
  nazov VARCHAR2(30) NOT NULL UNIQUE PRIMARY KEY

)
Error report -
SQL Error: ORA-02259: duplicitné UNIQUE/PRIMARY KEY špecifikácie
02259. 00000 -  "duplicate UNIQUE/PRIMARY KEY specifications"
*Cause:    Self-evident.
*Action:   Remove the duplicate specification.
Table LIECBA created.

Table DOPORUCENE_DAVKOVANIE created.

Table DAVKOVANIE created.

Table DIAGNOZA created.

Table LIECBA_DAVKOVANIE_LIEK created.

Error starting at line : 108 in command -
CREATE TABLE liek_diagnoza_doporucene_druh(
	nazov_liek VARCHAR2(30) NOT NULL UNIQUE PRIMARY KEY,
	id_diagnoza NUMBER NOT NULL,
	id_doporucene_davkovanie NUMBER NOT NULL,
	nazov_druh_zvierata VARCHAR2(30) NOT NULL UNIQUE
)
Error report -
SQL Error: ORA-02259: duplicitné UNIQUE/PRIMARY KEY špecifikácie
02259. 00000 -  "duplicate UNIQUE/PRIMARY KEY specifications"
*Cause:    Self-evident.
*Action:   Remove the duplicate specification.
Table INFORMACIE_O_CLOVEKU altered.

Table MAJITEL altered.

Table ZAMESTNANEC altered.

Table ZVIERA altered.

Table LIECBA altered.

Table DOPORUCENE_DAVKOVANIE altered.

Table DAVKOVANIE altered.

Table DIAGNOZA altered.


Error starting at line : 127 in command -

Error report -
Unknown Command

Table MAJITEL altered.

Table ZAMESTNANEC altered.


Error starting at line : 133 in command -
ALTER TABLE  zamestnanec ADD CONSTRAINT FK_titul FOREIGN KEY(nazov_titul) REFERENCES titul
Error report -
SQL Error: ORA-00942: tabuľka alebo pohľad neexistuje
00942. 00000 -  "table or view does not exist"
*Cause:
*Action:
Error starting at line : 134 in command -
ALTER TABLE  zamestnanec ADD CONSTRAINT FK_profesia FOREIGN KEY(nazov_profesia) REFERENCES profesia
Error report -
SQL Error: ORA-00942: tabuľka alebo pohľad neexistuje
00942. 00000 -  "table or view does not exist"
*Cause:
*Action:

Error starting at line : 135 in command -
ALTER TABLE  zviera ADD CONSTRAINT FK_druh_zvierata FOREIGN KEY(nazov_druh_zvierata) REFERENCES druh_zvierata
Error report -
SQL Error: ORA-00942: tabuľka alebo pohľad neexistuje
00942. 00000 -  "table or view does not exist"
*Cause:
*Action:
Error starting at line : 136 in command -
ALTER TABLE  zviera ADD CONSTRAINT FK_kontraindikace FOREIGN KEY(nazov_kontraindikace) REFERENCES kontraindikacia
Error report -
SQL Error: ORA-00942: tabuľka alebo pohľad neexistuje
00942. 00000 -  "table or view does not exist"
*Cause:
*Action:
Table ZVIERA altered.

Table LIECBA altered.

Table LIECBA altered.


Error starting at line : 140 in command -
ALTER TABLE  liek ADD CONSTRAINT FK_ucinna_latka FOREIGN KEY(nazov_ucinna_latka) REFERENCES ucinna_latka
Error report -
SQL Error: ORA-00942: tabuľka alebo pohľad neexistuje
00942. 00000 -  "table or view does not exist"
*Cause:
*Action:
Error starting at line : 141 in command -
ALTER TABLE	 liek ADD CONSTRAINT FK_kontraindikace_2 FOREIGN KEY(nazov_kontraindikace) REFERENCES kontraindikacia
Error report -
SQL Error: ORA-00942: tabuľka alebo pohľad neexistuje
00942. 00000 -  "table or view does not exist"
*Cause:
*Action:
Table DAVKOVANIE altered.

Table LIECBA_DAVKOVANIE_LIEK altered.

Table LIECBA_DAVKOVANIE_LIEK altered.


Error starting at line : 145 in command -
ALTER TABLE  liecba_davkovanie_liek ADD CONSTRAINT FK_liek FOREIGN KEY(nazov_liek) REFERENCES liek
Error report -
SQL Error: ORA-00942: tabuľka alebo pohľad neexistuje
00942. 00000 -  "table or view does not exist"
*Cause:
*Action:
Error starting at line : 146 in command -
ALTER TABLE  liek_diagnoza_doporucene_druh ADD CONSTRAINT FK_liek_2 FOREIGN KEY(nazov_liek) REFERENCES liek
Error report -
SQL Error: ORA-00942: tabuľka alebo pohľad neexistuje
00942. 00000 -  "table or view does not exist"
*Cause:
*Action:

Error starting at line : 147 in command -
ALTER TABLE  liek_diagnoza_doporucene_druh ADD CONSTRAINT FK_diagnoza_2 FOREIGN KEY(id_diagnoza) REFERENCES diagnoza
Error report -
SQL Error: ORA-00942: tabuľka alebo pohľad neexistuje
00942. 00000 -  "table or view does not exist"
*Cause:
*Action:
Error starting at line : 148 in command -
ALTER TABLE  liek_diagnoza_doporucene_druh ADD CONSTRAINT FK_doporucene_davkovanie FOREIGN KEY(id_doporucene_davkovanie) REFERENCES doporucene_davkovanie
Error report -
SQL Error: ORA-00942: tabuľka alebo pohľad neexistuje
00942. 00000 -  "table or view does not exist"
*Cause:
*Action:

Error starting at line : 149 in command -
ALTER TABLE  liek_diagnoza_doporucene_druh ADD CONSTRAINT FK_druh_zvierata_2 FOREIGN KEY(nazov_druh_zvierata) REFERENCES druh_zvierata
Error report -
SQL Error: ORA-00942: tabuľka alebo pohľad neexistuje
00942. 00000 -  "table or view does not exist"
*Cause:
*Action:

Commit complete.