Database Utilities (MOSC)

MOSC Banner

impdp import have so many issue user can not create and procedure create error

Hi,
env is 12.2.0.1.0
souce database expdp as below:
expdp \'/ as sysdba\' directory=dumpddl dumpfile=ddlnew.dmp full=y CONTENT=METADATA_only EXCLUDE=TABLE_STATISTICS EXCLUDE=INDEX_STATISTICS
target database:
impdp \'/ as sysdba\' directory=ddldump dumpfile=ddlnew.dmp REMAP_TABLESPACE=A:target tablespace  CONTENT=METADATA_ONLY logfile=import.log

like some error message:
BEGIN
sys.dbms_logrep_imp.prepare_object(table_owner=>'STUB_RPT_USER', table_name=>'ORDER_METRICS_DLY_AGG_GTT', flags=>0);COMMIT; END;
ORA-39083: Object type PROCACT_SCHEMA:"SYS" failed to create with error:
ORA-00942: table or view does not exist
sys.dbms_scheduler.s

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center