API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 3rd, 2018
101
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Oracle 11 8.21 KB | None | 0 0
raw download clone embed print report
  1. import done IN EE8MSWIN1250 character SET AND AL16UTF16 NCHAR character SET
  2. import server uses AL32UTF8 character SET (possible charset conversion)
  3. export client uses US7ASCII character SET (possible charset conversion)
  4. . importing SOC_POISTOVNA's objects into KISKA2
  5. IMP-00015: following statement failed because the object already exists:
  6. "CREATE TYPE "T_OSOBA" TIMESTAMP '2016-10-20:12:34:15' OID '3F4A77A03C6996A9"
  7. "E050C19E128A459A'   is object"
  8. "(rod_cislo char(11),"
  9. " meno varchar2(20),"
  10. " priezvisko varchar2(30),"
  11. " psc char(5),"
  12. " ulica varchar2(50));"
  13. IMP-00061: Warning: Object type "KISKA2"."T_OSOBA" already exists with a different identifier
  14. IMP-00063: Warning: Skipping table "KISKA2"."P_OSOBA" because object type "KISKA2"."T_OSOBA" cannot be created or has different identifier
  15. IMP-00015: following statement failed because the object already exists:
  16. "CREATE TABLE "P_ZAMESTNAVATEL" ("ICO" CHAR(11) NOT NULL ENABLE, "NAZOV" VAR"
  17. "CHAR2(30) NOT NULL ENABLE, "PSC" CHAR(5) NOT NULL ENABLE, "ULICA" VARCHAR2("
  18. "50) NOT NULL ENABLE)  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE"
  19. "(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFF"
  20. "ER_POOL DEFAULT)                       LOGGING NOCOMPRESS"
  21. IMP-00015: following statement failed because the object already exists:
  22. "CREATE TABLE "P_POISTENIE" ("ID_POISTENCA" NUMBER NOT NULL ENABLE, "ROD_CIS"
  23. "LO" CHAR(11) NOT NULL ENABLE, "ID_PLATITELA" CHAR(11), "OSLOBODENY" CHAR(1)"
  24. " NOT NULL ENABLE, "DAT_OD" DATE NOT NULL ENABLE, "DAT_DO" DATE)  PCTFREE 10"
  25. " PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 589824 NEXT 1048576 MIN"
  26. "EXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)               "
  27. "        LOGGING NOCOMPRESS"
  28. IMP-00015: following statement failed because the object already exists:
  29. "CREATE TABLE "P_ZAMESTNANEC" ("ID_ZAMESTNAVATELA" CHAR(11) NOT NULL ENABLE,"
  30. " "ROD_CISLO" CHAR(11) NOT NULL ENABLE, "DAT_OD" DATE NOT NULL ENABLE, "DAT_"
  31. "DO" DATE, "ID_POISTENCA" NUMBER)  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS"
  32. " 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST G"
  33. "ROUPS 1 BUFFER_POOL DEFAULT)                       LOGGING NOCOMPRESS"
  34. IMP-00015: following statement failed because the object already exists:
  35. "CREATE TABLE "P_ODVOD_PLATBA" ("CIS_PLATBY" NUMBER NOT NULL ENABLE, "ID_POI"
  36. "STENCA" NUMBER NOT NULL ENABLE, "SUMA" NUMBER NOT NULL ENABLE, "DAT_PLATBY""
  37. " DATE NOT NULL ENABLE, "OBDOBIE" DATE NOT NULL ENABLE)  PCTFREE 10 PCTUSED "
  38. "40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 11534336 NEXT 1048576 MINEXTENTS"
  39. " 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)                      "
  40. " LOGGING NOCOMPRESS"
  41. IMP-00015: following statement failed because the object already exists:
  42. "CREATE TABLE "P_POBERATEL" ("ID_POBERATELA" NUMBER NOT NULL ENABLE, "ROD_CI"
  43. "SLO" CHAR(11) NOT NULL ENABLE, "PERC_VYJ" FLOAT(63) NOT NULL ENABLE, "DAT_O"
  44. "D" DATE NOT NULL ENABLE, "DAT_DO" DATE, "ID_TYPU" NUMBER(*,0) NOT NULL ENAB"
  45. "LE)  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 655360 N"
  46. "EXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)"
  47. "                       LOGGING NOCOMPRESS"
  48. IMP-00015: following statement failed because the object already exists:
  49. "CREATE TABLE "P_ZTP" ("ID_ZTP" CHAR(6) NOT NULL ENABLE, "ROD_CISLO" CHAR(11"
  50. ") NOT NULL ENABLE, "DAT_OD" DATE NOT NULL ENABLE, "DAT_DO" DATE, "ID_POSTIH"
  51. "NUTIA" NUMBER NOT NULL ENABLE)  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 2"
  52. "55 STORAGE(INITIAL 327680 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GR"
  53. "OUPS 1 BUFFER_POOL DEFAULT)                       LOGGING NOCOMPRESS"
  54. IMP-00015: following statement failed because the object already exists:
  55. "CREATE TABLE "P_PLATITEL" ("ID_PLATITELA" CHAR(11) NOT NULL ENABLE)  PCTFRE"
  56. "E 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 131072 NEXT 1048576"
  57. " MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)           "
  58. "            LOGGING NOCOMPRESS"
  59. IMP-00015: following statement failed because the object already exists:
  60. "CREATE TABLE "P_PRISPEVKY" ("ID_POBERATELA" NUMBER NOT NULL ENABLE, "OBDOBI"
  61. "E" DATE NOT NULL ENABLE, "KEDY" DATE NOT NULL ENABLE, "SUMA" NUMBER NOT NUL"
  62. "L ENABLE, "ID_TYPU" NUMBER(*,0) NOT NULL ENABLE)  PCTFREE 10 PCTUSED 40 INI"
  63. "TRANS 1 MAXTRANS 255 STORAGE(INITIAL 28311552 NEXT 1048576 MINEXTENTS 1 FRE"
  64. "ELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)                       LOGGI"
  65. "NG NOCOMPRESS"
  66. IMP-00015: following statement failed because the object already exists:
  67. "CREATE TABLE "P_MESTO" ("PSC" CHAR(5) NOT NULL ENABLE, "N_MESTA" VARCHAR2(3"
  68. "0) NOT NULL ENABLE, "ID_OKRESU" CHAR(2) NOT NULL ENABLE)  PCTFREE 10 PCTUSE"
  69. "D 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS "
  70. "1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)                       "
  71. "LOGGING NOCOMPRESS"
  72. IMP-00015: following statement failed because the object already exists:
  73. "CREATE TABLE "P_OKRES" ("ID_OKRESU" CHAR(2) NOT NULL ENABLE, "N_OKRESU" VAR"
  74. "CHAR2(30) NOT NULL ENABLE, "ID_KRAJA" CHAR(2) NOT NULL ENABLE)  PCTFREE 10 "
  75. "PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEX"
  76. "TENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)                 "
  77. "      LOGGING NOCOMPRESS"
  78. IMP-00015: following statement failed because the object already exists:
  79. "CREATE TABLE "P_KRAJ" ("ID_KRAJA" CHAR(2) NOT NULL ENABLE, "N_KRAJA" VARCHA"
  80. "R2(30) NOT NULL ENABLE, "ID_KRAJINY" CHAR(3) NOT NULL ENABLE)  PCTFREE 10 P"
  81. "CTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXT"
  82. "ENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)                  "
  83. "     LOGGING NOCOMPRESS"
  84. IMP-00015: following statement failed because the object already exists:
  85. "CREATE TABLE "P_KRAJINA" ("ID_KRAJINY" CHAR(3) NOT NULL ENABLE, "N_KRAJINY""
  86. " VARCHAR2(30) NOT NULL ENABLE)  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 2"
  87. "55 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GRO"
  88. "UPS 1 BUFFER_POOL DEFAULT)                       LOGGING NOCOMPRESS"
  89. IMP-00015: following statement failed because the object already exists:
  90. "CREATE TABLE "P_TYP_POSTIHNUTIA" ("ID_POSTIHNUTIA" NUMBER NOT NULL ENABLE, "
  91. ""NAZOV_POSTIHNUTIA" VARCHAR2(50))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRAN"
  92. "S 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST "
  93. "GROUPS 1 BUFFER_POOL DEFAULT)                       LOGGING NOCOMPRESS"
  94. IMP-00015: following statement failed because the object already exists:
  95. "CREATE TYPE "T_REC_TPRISPEVOK_HIST" TIMESTAMP '2016-11-03:10:45:22' OID '40"
  96. "4D1B7DBB393D39E050C19E128A0B70'   is object"
  97. "("
  98. "   dat_od date,"
  99. "   dat_do date,"
  100. "   zakl_vyska float"
  101. ");"
  102. IMP-00015: following statement failed because the object already exists:
  103. "CREATE TYPE "T_TPRISPEVOK_HIST" TIMESTAMP '2016-11-03:10:48:29' OID '404D1B"
  104. "7DBB3F3D39E050C19E128A0B70'    is table of t_rec_tprispevok_hist;"
  105. IMP-00015: following statement failed because the object already exists:
  106. "CREATE TABLE "P_TYP_PRISPEVKU" ("POPIS" VARCHAR2(10) NOT NULL ENABLE, "ZAKL"
  107. "_VYSKA" NUMBER NOT NULL ENABLE, "ID_TYPU" NUMBER(*,0), "HISTORIA" "T_TPRISP"
  108. "EVOK_HIST")  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL "
  109. "65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL D"
  110. "EFAULT)                       LOGGING NOCOMPRESS NESTED TABLE "HISTORIA" ST"
  111. "ORE AS "T_TPRISPEVOK_HIST_TAB"( PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 2"
  112. "55 LOGGING STORAGE(INITIAL 851968 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FRE"
  113. "ELIST GROUPS 1 BUFFER_POOL DEFAULT))  RETURN AS VALUE "
  114. IMP-00015: following statement failed because the object already exists:
  115. "ALTER TABLE "P_OSOBA" ADD FOREIGN KEY ("PSC") REFERENCES "P_MESTO" ("PSC") "
  116. "ENABLE"
  117. IMP-00015: following statement failed because the object already exists:
  118. "ALTER TABLE "P_OSOBA" ADD FOREIGN KEY ("ROD_CISLO") REFERENCES "P_PLATITEL""
  119. " ("ID_PLATITELA") ENABLE"
  120. IMP-00017: following statement failed with ORACLE error 942:
  121. "ANALYZE  TABLE "T_TPRISPEVOK_HIST_TAB"  ESTIMATE STATISTICS "
  122. IMP-00003: ORACLE error 942 encountered
  123. ORA-00942: table or view does not exist
  124. Import terminated successfully with warnings.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!