Home > Oracle Bug > ORA-39083: Object type OBJECT_GRANT failed to create with error:

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

I imported a schema from Oracle 11.2.0.1 database to Oracle 11.1.0.7 database.  I got the following errors

ERRORS

Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-00990: missing or invalid privilege
Failing sql is:
GRANT  ON “UNI_EDS3″.”PON_SEQID” TO “UNI_MLVPNX”

ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-00990: missing or invalid privilege
Failing sql is:
GRANT  ON “UNI_EDS3″.”PON_SEQID” TO “UNI_PON”

ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-00990: missing or invalid privilege
Failing sql is:
GRANT  ON “UNI_EDS3″.”COM_EXCH_MT_KEY” TO “UNI_MLVPNX”

After checking with support oracle, I got that it is bug. The details is referred to the Doc ID 1069105.11.  The solutions is applied the Patch 8856467. After patching the Oracle 11.2.0.1. it works

 

 

Advertisements
Categories: Oracle Bug
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: