1 Reply Latest reply: Sep 10, 2013 9:15 AM by DK2010 RSS

    Using exp/imp appears to fail

    b63f779f-bc82-4f62-adb1-8847b7dba92a

      Hello Everyone.

       

      We are trying to export a set of table from one Oracle Database to another and have come across a problem.

      Exporting via PL/SQL developer (v7) appears to be fine but when we try to import the generated .dmp file using the imp tool, it fails with this error:

       

      IMP-00017: following statement failed with ORACLE error 905:

      "CREATE TABLE "GEOM_TABLE" ("UUID" VARCHAR2(36) NOT NULL ENABLE, ""

      "NAME" VARCHAR2(50), "ORDINATES" "MDSYS"."SDO_GEOMETRY", "DRAWING_UUID" VARC"

      "HAR2(36))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65"

      "536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "GEOM_SPACE"

      "" LOGGING NOCOMPRESS VARRAY "ORDINATES"."SDO_ELEM_INFO" ELEMENT  STORE AS L"

      "OB  (ENABLE STORAGE IN ROW CHUNK 16384 RETENTION  CACHE  STORAGE(INITIAL 65"

      "536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) VARRAY "ORDINATES"."

      ""SDO_ORDINATES" ELEMENT  STORE AS LOB  (ENABLE STORAGE IN ROW CHUNK 16384 R"

      "ETENTION  CACHE  STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER"

      "_POOL DEFAULT)) COLUMN "ORDINATES" NOT SUBSTITUTABLE AT ALL LEVELS "

      IMP-00003: ORACLE error 905 encountered

      ORA-00905: missing keyword

       

      This only appears to happen when there is a reference to MYSYS.SDO_GEOMETRY. It is preventing the data migration from completing so does anyone have any ideas?

       

      Thanks in advance.