Best way to move data, medata & Privs from DB-1 to DB-2
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..