Use of Programmatic Interface of DBMS_METADATA

[GoogleCodeExporter]

Need to enhance the feature of tool to use Programmatic Interface of 
DBMS_METADATA package.

e.g. REMAP_SCHEMA, it will help us to generate the script with different schema 
prefix or no schema prefix.

http://docs.oracle.com/cd/B28359_01/server.111/b28319/metadata_api.htm#i1010762
DBMS_METADATA.SET_REMAP_PARAM(th,'REMAP_SCHEMA','HR','SCOTT');
DBMS_METADATA.SET_REMAP_PARAM(th,'REMAP_SCHEMA','HR','');

We can map the schema names or tablespace names , use remap parameters and the 
SET_REMAP_PARAM procedure.

Original issue reported on code.google.com by [email protected] on 8 Jun 2013 at 2:57

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Original comment by [email protected] on 16 Feb 2015 at 5:06

• Added labels: Priority-Medium
• Removed labels: Priority-High

[teopost]

This feature would be very useful !