I want to do a full impdp but im getting many errors.
impdp user/password@database directory=DATA_PUMP_DIR
im trying to do this in my laptop for test purpose. I am using 184.108.40.206.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=
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
im still not gettin nywher.......
as i mentioned this is a test machine so
no users, no tablespaces, no schemas are created in this test machine jst oracle has been installled.
Please suggest me what to be done next.
From the production DB i have taken the full=y expdp