Hi!
We have following constellation in 11.2.0.4:
Production database has 2 schemas. tables of schema1 (central utilities) are granted to schema2:
In development database schema2 does not exist, as it is legacy and no development happened on this anymore, costs for this should be avoided.
When refreshing development from production following errors occur:
ORA-39083: Object type OBJECT_GRANT failed to create with error
ORA-01917: user or role SCHEMA2 does not exist
grant insert, update, select, delete on schema1.table to schema2 with grant option
As the refresh process should be automated these errors should be eliminated.
Is this possible?
Datapump import EXCLUDE=GRANT parameter seems only to exlude all grants.
Datapump import EXCLUDE=SCHEMA: "= 'SCHEMA2' " and EXCLUDE=SCHEMA2 seems not exclude the grants from schema1 to schema2.
Kind regards
Torsten