Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import done IN EE8MSWIN1250 character SET AND AL16UTF16 NCHAR character SET
- import server uses AL32UTF8 character SET (possible charset conversion)
- export client uses US7ASCII character SET (possible charset conversion)
- . importing SOC_POISTOVNA's objects into KISKA2
- IMP-00015: following statement failed because the object already exists:
- "CREATE TYPE "T_OSOBA" TIMESTAMP '2016-10-20:12:34:15' OID '3F4A77A03C6996A9"
- "E050C19E128A459A' is object"
- "(rod_cislo char(11),"
- " meno varchar2(20),"
- " priezvisko varchar2(30),"
- " psc char(5),"
- " ulica varchar2(50));"
- IMP-00061: Warning: Object type "KISKA2"."T_OSOBA" already exists with a different identifier
- IMP-00063: Warning: Skipping table "KISKA2"."P_OSOBA" because object type "KISKA2"."T_OSOBA" cannot be created or has different identifier
- IMP-00015: following statement failed because the object already exists:
- "CREATE TABLE "P_ZAMESTNAVATEL" ("ICO" CHAR(11) NOT NULL ENABLE, "NAZOV" VAR"
- "CHAR2(30) NOT NULL ENABLE, "PSC" CHAR(5) NOT NULL ENABLE, "ULICA" VARCHAR2("
- "50) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE"
- "(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFF"
- "ER_POOL DEFAULT) LOGGING NOCOMPRESS"
- IMP-00015: following statement failed because the object already exists:
- "CREATE TABLE "P_POISTENIE" ("ID_POISTENCA" NUMBER NOT NULL ENABLE, "ROD_CIS"
- "LO" CHAR(11) NOT NULL ENABLE, "ID_PLATITELA" CHAR(11), "OSLOBODENY" CHAR(1)"
- " NOT NULL ENABLE, "DAT_OD" DATE NOT NULL ENABLE, "DAT_DO" DATE) PCTFREE 10"
- " PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 589824 NEXT 1048576 MIN"
- "EXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
- " LOGGING NOCOMPRESS"
- IMP-00015: following statement failed because the object already exists:
- "CREATE TABLE "P_ZAMESTNANEC" ("ID_ZAMESTNAVATELA" CHAR(11) NOT NULL ENABLE,"
- " "ROD_CISLO" CHAR(11) NOT NULL ENABLE, "DAT_OD" DATE NOT NULL ENABLE, "DAT_"
- "DO" DATE, "ID_POISTENCA" NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS"
- " 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST G"
- "ROUPS 1 BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS"
- IMP-00015: following statement failed because the object already exists:
- "CREATE TABLE "P_ODVOD_PLATBA" ("CIS_PLATBY" NUMBER NOT NULL ENABLE, "ID_POI"
- "STENCA" NUMBER NOT NULL ENABLE, "SUMA" NUMBER NOT NULL ENABLE, "DAT_PLATBY""
- " DATE NOT NULL ENABLE, "OBDOBIE" DATE NOT NULL ENABLE) PCTFREE 10 PCTUSED "
- "40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 11534336 NEXT 1048576 MINEXTENTS"
- " 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
- " LOGGING NOCOMPRESS"
- IMP-00015: following statement failed because the object already exists:
- "CREATE TABLE "P_POBERATEL" ("ID_POBERATELA" NUMBER NOT NULL ENABLE, "ROD_CI"
- "SLO" CHAR(11) NOT NULL ENABLE, "PERC_VYJ" FLOAT(63) NOT NULL ENABLE, "DAT_O"
- "D" DATE NOT NULL ENABLE, "DAT_DO" DATE, "ID_TYPU" NUMBER(*,0) NOT NULL ENAB"
- "LE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 655360 N"
- "EXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)"
- " LOGGING NOCOMPRESS"
- IMP-00015: following statement failed because the object already exists:
- "CREATE TABLE "P_ZTP" ("ID_ZTP" CHAR(6) NOT NULL ENABLE, "ROD_CISLO" CHAR(11"
- ") NOT NULL ENABLE, "DAT_OD" DATE NOT NULL ENABLE, "DAT_DO" DATE, "ID_POSTIH"
- "NUTIA" NUMBER NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 2"
- "55 STORAGE(INITIAL 327680 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GR"
- "OUPS 1 BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS"
- IMP-00015: following statement failed because the object already exists:
- "CREATE TABLE "P_PLATITEL" ("ID_PLATITELA" CHAR(11) NOT NULL ENABLE) PCTFRE"
- "E 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 131072 NEXT 1048576"
- " MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
- " LOGGING NOCOMPRESS"
- IMP-00015: following statement failed because the object already exists:
- "CREATE TABLE "P_PRISPEVKY" ("ID_POBERATELA" NUMBER NOT NULL ENABLE, "OBDOBI"
- "E" DATE NOT NULL ENABLE, "KEDY" DATE NOT NULL ENABLE, "SUMA" NUMBER NOT NUL"
- "L ENABLE, "ID_TYPU" NUMBER(*,0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INI"
- "TRANS 1 MAXTRANS 255 STORAGE(INITIAL 28311552 NEXT 1048576 MINEXTENTS 1 FRE"
- "ELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) LOGGI"
- "NG NOCOMPRESS"
- IMP-00015: following statement failed because the object already exists:
- "CREATE TABLE "P_MESTO" ("PSC" CHAR(5) NOT NULL ENABLE, "N_MESTA" VARCHAR2(3"
- "0) NOT NULL ENABLE, "ID_OKRESU" CHAR(2) NOT NULL ENABLE) PCTFREE 10 PCTUSE"
- "D 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS "
- "1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
- "LOGGING NOCOMPRESS"
- IMP-00015: following statement failed because the object already exists:
- "CREATE TABLE "P_OKRES" ("ID_OKRESU" CHAR(2) NOT NULL ENABLE, "N_OKRESU" VAR"
- "CHAR2(30) NOT NULL ENABLE, "ID_KRAJA" CHAR(2) NOT NULL ENABLE) PCTFREE 10 "
- "PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEX"
- "TENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
- " LOGGING NOCOMPRESS"
- IMP-00015: following statement failed because the object already exists:
- "CREATE TABLE "P_KRAJ" ("ID_KRAJA" CHAR(2) NOT NULL ENABLE, "N_KRAJA" VARCHA"
- "R2(30) NOT NULL ENABLE, "ID_KRAJINY" CHAR(3) NOT NULL ENABLE) PCTFREE 10 P"
- "CTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXT"
- "ENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
- " LOGGING NOCOMPRESS"
- IMP-00015: following statement failed because the object already exists:
- "CREATE TABLE "P_KRAJINA" ("ID_KRAJINY" CHAR(3) NOT NULL ENABLE, "N_KRAJINY""
- " VARCHAR2(30) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 2"
- "55 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GRO"
- "UPS 1 BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS"
- IMP-00015: following statement failed because the object already exists:
- "CREATE TABLE "P_TYP_POSTIHNUTIA" ("ID_POSTIHNUTIA" NUMBER NOT NULL ENABLE, "
- ""NAZOV_POSTIHNUTIA" VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRAN"
- "S 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST "
- "GROUPS 1 BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS"
- IMP-00015: following statement failed because the object already exists:
- "CREATE TYPE "T_REC_TPRISPEVOK_HIST" TIMESTAMP '2016-11-03:10:45:22' OID '40"
- "4D1B7DBB393D39E050C19E128A0B70' is object"
- "("
- " dat_od date,"
- " dat_do date,"
- " zakl_vyska float"
- ");"
- IMP-00015: following statement failed because the object already exists:
- "CREATE TYPE "T_TPRISPEVOK_HIST" TIMESTAMP '2016-11-03:10:48:29' OID '404D1B"
- "7DBB3F3D39E050C19E128A0B70' is table of t_rec_tprispevok_hist;"
- IMP-00015: following statement failed because the object already exists:
- "CREATE TABLE "P_TYP_PRISPEVKU" ("POPIS" VARCHAR2(10) NOT NULL ENABLE, "ZAKL"
- "_VYSKA" NUMBER NOT NULL ENABLE, "ID_TYPU" NUMBER(*,0), "HISTORIA" "T_TPRISP"
- "EVOK_HIST") PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL "
- "65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL D"
- "EFAULT) LOGGING NOCOMPRESS NESTED TABLE "HISTORIA" ST"
- "ORE AS "T_TPRISPEVOK_HIST_TAB"( PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 2"
- "55 LOGGING STORAGE(INITIAL 851968 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FRE"
- "ELIST GROUPS 1 BUFFER_POOL DEFAULT)) RETURN AS VALUE "
- IMP-00015: following statement failed because the object already exists:
- "ALTER TABLE "P_OSOBA" ADD FOREIGN KEY ("PSC") REFERENCES "P_MESTO" ("PSC") "
- "ENABLE"
- IMP-00015: following statement failed because the object already exists:
- "ALTER TABLE "P_OSOBA" ADD FOREIGN KEY ("ROD_CISLO") REFERENCES "P_PLATITEL""
- " ("ID_PLATITELA") ENABLE"
- IMP-00017: following statement failed with ORACLE error 942:
- "ANALYZE TABLE "T_TPRISPEVOK_HIST_TAB" ESTIMATE STATISTICS "
- IMP-00003: ORACLE error 942 encountered
- ORA-00942: table or view does not exist
- Import terminated successfully with warnings.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement