OraFAQ Forum: Server Administration » Regarding DBMS

Home » RDBMS Server » Server Administration » Regarding DBMS_METADATA

Tue, 25 April 2006 09:38

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Hi all,

I am trying to get the dependent objects on emp table.

I want the constraints on emp table.

Select dbms_metadata.get_dependent_ddl('CONSTRAINT','EMP','SCOTT') from dual;

I am getting only the primary key.

Also want to get the definition of Foreign Key.

Thanks in Advance
Salih KM

Tue, 25 April 2006 09:47

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Tue, 25 April 2006 10:08

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Thanks Mahesh. Cool

Previous Topic:	RAW device
Next Topic:	DBMS_JOB

Goto Forum:

]

Current Time: Fri Sep 20 13:49:24 CDT 2024