Database Utilities (MOSC)

MOSC Banner

Migration of 11g DB from linux to solaris - Imported with errors

edited Jun 18, 2018 5:18AM in Database Utilities (MOSC) 7 commentsAnswered ✓

Hello Team,

We are trying to migration 11g database from linux to solaris.After importing showing below error

Failing sql is:

BEGIN

execute immediate ('CREATE TABLE TEMP_JAVA_PRIVS AS SELECT KIND, GRANTEE, TYPE_SCHEMA,

TYPE_NAME, NAME, ACTION, ENABLED FROM DBA_JAVA_POLICY WHERE ROWNUM > 1');COMMIT; END;

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 'OLAP_DBA' does not exist

Failing sql is:

GRANT SELECT ON "ORDDATA"."ORDDCM_DOCS_ID_SEQ" TO "ORDSYS"

ORA-39083: Object type OBJECT_GRANT failed to create with error:

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