public synonyms and roles when moving a db with data pump
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?
0