1 2 Previous Next 15 Replies Latest reply on Nov 28, 2012 5:29 AM by saurabh

    impdp errors

      Hello all,

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

      im using

      impdp user/password@database directory=DATA_PUMP_DIR

      im trying to do this in my laptop for test purpose. I am using 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=
      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