Discussions
impdp ORA-39083: Object type SYSTEM_GRANT failed to create with error
Hello Gurus,
I am in version database enterprise edition 12.1.0.2 and I try to execute an expdp ( full ).
and impdp full. exception ( SYS, SYSTEM, and all the schema admin ) then when I execute impdp I have several errors like this next
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
ORA-39083: Object type SYSTEM_GRANT failed to create with error:
ORA-01917: user or role 'FLOWS_FILES' does not exist
Failing sql is:
GRANT CREATE SYNONYM TO "FLOWS_FILES"
ORA-39083: Object type SYSTEM_GRANT failed to create with error:
ORA-01917: user or role 'APEX_PUBLIC_USER' does not exist
Failing sql is:
Tagged:
0