Database Utilities (MOSC)

MOSC Banner

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');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center