This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Nov 27, 2012 9:29 PM by saurabh RSS

impdp errors

951027 Newbie
Currently Being Moderated
Hello all,

I want to do a full impdp but im getting many errors.



im using

impdp user/password@database directory=DATA_PUMP_DIR
FULL=Y
dumpfile=EXPORT.DMP

im trying to do this in my laptop for test purpose. I am using 11.2.0.1.0 version.

1. cn i do this with sys user? IF im doing from sys user its giving me errors like

ORA-31625: Schema Example is needed to import this object, but is unaccessible
ORA-39083: Object type PACKAGE_BODY failed to create with error:

ORA-39083: Object type SYNONYM failed to create with error:
ORA-01917: user or role '' does not exist



2. Whn im trying to do this with user with full imp privileges im gettin error.

ORA-31655: no data or metadata objects selected for job
ORA-39154: Objects from foreign schemas have been removed from import
Master table "ABC"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "ABC"."SYS_IMPORT_FULL_01": abc/******** directory=DATA_PUMP_DIR FULL=
Y DUMPFILE=ORCL.DMP
Job "ABC"."SYS_IMPORT_FULL_01" successfully completed at 11:42:49



please suggest how to over come this


In the laptop where im trying to do impdp I haven't created any directory structure,, no tablespaces, no users I jst installed oracle
1 2 Previous Next

Legend

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