Database Utilities (MOSC)

MOSC Banner

Best way to move data, medata & Privs from DB-1 to DB-2

edited Jun 25, 2014 11:47AM in Database Utilities (MOSC) 8 commentsAnswered

Hi Team, 

About a week ago or so, I wanted to refresh one our Dev schema, I exported it from our Prod DB using expdp and imported it to Dev DB.  All data was imported successfully, but some Privs, roles didn't make it and some packages compiled with errors.  I pasted some of the errors below fyi:

ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01917: user or role 'SEARCH1WEB' does not exist


Failing sql is:

GRANT EXECUTE ON "SEARCH1"."ID_ARRAY" TO "SEARCH1WEB"

I expected if a role doesn't exist on the destination DB, it should be created during the import, and also the GRANT EXECUTE and all the Privs should be applied during import since I am bring everything over..

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