Start a new topic

DDL for foreign key constraint (Oracle)

anonymous

started a topic over 16 years ago

[This topic is migrated from our old forums. The original author name has been removed]

Hi,
When you try to display the DDL for a foreign key constraint in Oracle databases, the you get an error: ORA-31603

The command you try to use is:
{color:#0000ff}
select DBMS_METADATA.GET_DDL('CONSTRAINT', <name>, <owner>) from dual{color}

You have to use the 'REF_CONSTRAINT' parameter in DBMS_METADATA.GET_DDL if you want to extract the DDL for a foreign key contraint, also:
{color:#0000ff}
select DBMS_METADATA.GET_DDL('REF_CONSTRAINT', <name>, <owner>) from dual{color}

Regards

1 Comment

Roger Bjärevall

said over 16 years ago

[This reply is migrated from our old forums.]

Re: DDL for foreign key constraint (Oracle)

Csaba,

This will be fixed in the next version.

Thanks for letting us know.

Best Regards

Roger

How can we help you today?

DDL for foreign key constraint (Oracle)

anonymous

Roger Bjärevall