Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error while trying to import .dmp file in oracle

878401Jul 27 2011 — edited Aug 2 2011
Hi,
I am trying to import a .dmp file using impdp command. Whenever I try that I get following error logs:

Import: Release 10.2.0.1.0 - Production on Wednesday, 27 July, 2011 19:22:18

Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/******** DUMPFILE=HIST_IR_APR_2011.dmp
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE failed to create with error:
ORA-00439: feature not enabled: Partitioning
Failing sql is:
CREATE TABLE "DBO"."HIST_IR" ("IR_ID" NUMBER(9,0), "ELS_ID1" NUMBER(9,0), "ELS_ID2" NUMBER(9,0), "ZONE_ID" NUMBER(2,0) NOT NULL ENABLE, "TYPE" NUMBER(2,0) NOT NULL ENABLE, "START_TIME" DATE NOT NULL ENABLE, "END_TIME" DATE NOT NULL ENABLE, "ROAD_NAME" VARCHAR2(50) NOT NULL ENABLE, "UP_POINT" NUMBER(4,2), "DN_POINT" NUMBER(4,2), "UP_LINK_ID" NUMBER(9,0) NOT NULL ENABLE, "DN_LINK_ID" NUMBER
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-39112: Dependent object type OBJECT_GRANT:"DBO" skipped, base object type TABLE:"DBO"."HIST_IR" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"DBO" skipped, base object type TABLE:"DBO"."HIST_IR" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"DBO" skipped, base object type TABLE:"DBO"."HIST_IR" creation failed
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
ORA-39112: Dependent object type INDEX:"DBO"."INDX_HIST_IR_LOC_TYPE" skipped, base object type TABLE:"DBO"."HIST_IR" creation failed
ORA-39112: Dependent object type INDEX:"DBO"."INDX_HIST_IR_ROAD_NAME" skipped, base object type TABLE:"DBO"."HIST_IR" creation failed
ORA-39112: Dependent object type INDEX:"DBO"."INDX_HIST_IR_ELS_ID1" skipped, base object type TABLE:"DBO"."HIST_IR" creation failed
ORA-39112: Dependent object type INDEX:"DBO"."PK_HIST_IR" skipped, base object type TABLE:"DBO"."HIST_IR" creation failed
ORA-39112: Dependent object type INDEX:"DBO"."INDX_HIST_IR_START_TIME" skipped, base object type TABLE:"DBO"."HIST_IR" creation failed
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-39112: Dependent object type CONSTRAINT:"DBO"."PK_HIST_IR" skipped, base object type TABLE:"DBO"."HIST_IR" creation failed
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 10 error(s) at 19:22:21

Any idea how to get rid of the errors ?

BR///
Tayyab
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 30 2011
Added on Jul 27 2011
9 comments
603 views