This discussion is archived
1 Reply Latest reply: Sep 10, 2013 7:15 AM by DK2010 RSS

Using exp/imp appears to fail

b63f779f-bc82-4f62-adb1-8847b7dba92a Newbie
Currently Being Moderated

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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points