Technology Stack - EBS (MOSC)

MOSC Banner

Discussions

impdp ORA-39083: Object type SYSTEM_GRANT failed to create with error

edited Aug 20, 2021 11:52AM in Technology Stack - EBS (MOSC) 4 commentsAnswered

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:

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.

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center