ORACLE Get_DLL for Constraint using index -

ORACLE Get_DLL for Constraint using index -

i trying export constraint ddls oracle :

execute dbms_metadata.set_transform_param(dbms_metadata.session_transform,'storage',false); execute dbms_metadata.set_transform_param(dbms_metadata.session_transform,'tablespace',false); execute dbms_metadata.set_transform_param(dbms_metadata.session_transform,'segment_attributes',false); execute dbms_metadata.set_transform_param(dbms_metadata.session_transform,'sqlterminator',true); dbms_metadata.get_ddl ( 'constraint',myconstraint, me);

i

alter table "me"."mytable" add together constraint "myconstraint" primary key ("col1") enable;

i want

alter table "me"."mytable" add together constraint "myconstraint" primary key ("col1") using index myindex);

i couldn't find alternative in documentation oracle 11.2 : http://docs.oracle.com/cd/e11882_01/appdev.112/e25788/d_metada.htm#bgbjbfge

any thought how accomplish ?

this might help, or close:

select replace(dbms_metadata.get_ddl('constraint', constraint_name, user) ,' using index ' ,' using index "' || index_name || '" ' ) ddl user_constraints index_name not null , constraint_name not 'bin$%';

oracle constraints ddl