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 sarvindu...@gmail.com on 8 Jun 2013 at 2:57

[teopost]

This feature would be very useful !