DBMS_DATAPUMP CONSTRAINT_NAME_FROM_INDEX
Hello, I am using dbms_datapump to exp/imp data.
When importing I would like to set constraint_name_from_index to Y. Looking in impdp it seems to be related to TRANSFORM section
"The available transforms are as follows, in alphabetical order:
CONSTRAINT_NAME_FROM_INDEX: [Y | N ]"
I tried to use
DBMS_DATAPUMP.SET_PARAMETER(handle=>l_dp_handle,name=>'TRANSFORM',value=>'CONSTRAINT_NAME_FROM_INDEX:Y');
DBMS_DATAPUMP.SET_PARAMETER(handle=>l_dp_handle,name=>'CONSTRAINT_NAME_FROM_INDEX',value=>'Y');
and
DBMS_DATAPUMP.METADATA_TRANSFORM(handle=>l_dp_handle,name=>'TRANSFORM',value=>'CONSTRAINT_NAME_FROM_INDEX:Y');