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:
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:
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:
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
0