jl66
asked on
how to find/set the parameter in DBMS_DATAPUMP as REMAP_SCHEMA in impdp
in impdp, I can import a table to different schema as REMAP_SCHEMA=A:B from schema A to B, but is there any equalvent statement in DBMS_DATAPUMP, which I will do the same as impdp?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Perhaps I've missed something... isn't it what are you looking for?
"The METADATA_REMAP procedure is only supported for Import and SQL_FILE
operations. It enables you to apply commonly desired, predefined remappings to
the definition of objects as part of the transfer. If you need remaps that are not
supported within this procedure, you should do a preliminary SQL_FILE
operation to produce a SQL script corresponding to the dump file set. By editing
the DDL directly and then executing it, you can produce any remappings that you
need."
"The METADATA_REMAP procedure is only supported for Import and SQL_FILE
operations. It enables you to apply commonly desired, predefined remappings to
the definition of objects as part of the transfer. If you need remaps that are not
supported within this procedure, you should do a preliminary SQL_FILE
operation to produce a SQL script corresponding to the dump file set. By editing
the DDL directly and then executing it, you can produce any remappings that you
need."
ivostoykov: Sorry if I caused confusion.
My comment was asking jl66 if the METADATA_REMAP procedure would suit.
I must have been typing while you were posting.
My comment was asking jl66 if the METADATA_REMAP procedure would suit.
I must have been typing while you were posting.
ASKER