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

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 “XXXX″.”XXXX” TO “XXXX”

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

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: