1
In one environment I have 5 schemas that make grant
and synonym
among themselves, of which they are already working.
Now I need to duplicate that default environment for the customer environment, and I need to change the name of schemas, grant
and synonym
.
The part about changing the name of schemas resolution in IMPDP thus:
REMAP_SCHEMA=SCHEMAPADRAO:SCHEMACLIENTE
SCHEMAS=SCHEMAPADRAO
But I always have to redo the grant
and synonym
because they have an incorrect name.
I would like to resolve this in the IMPDP itself, but if it is not possible I would like another solution.
Not only would it rotate, it would have to change to do / TO, replacing, and conditions only for the
schemas
, that for thegrants
. As for thesynonyn
change to do theCREATE OR REPLACE
, I think it would work because that way I have all thegrants
andsynonym
registered. I will wait if there is a direct way in the IMP to accomplish this. Thank you Daniel– David