Database Administration (MOSC)

MOSC Banner

public synonyms and roles when moving a db with data pump

edited Feb 7, 2012 5:37AM in Database Administration (MOSC) 2 commentsAnswered
I've always wondered if there was some elegance in data pump that I was missing.  The problem I have is with regard to local public synonyms and local role definitions.  These don't seem to s come over with impdp INCLUDE=SCHEMA when I want to move just my local users to a new instance/system.  My klutzy method usually works, but it isn't pretty since I have to sort through hundreds of built-in public synonyms and roles and figure out what is locally created and what isn't.    Is there some way to get these moved without my hand holding?

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