Home » RDBMS Server » Server Administration » oracle Table and its dependent Object defination (10.2.0.4)
oracle Table and its dependent Object defination [message #431919] Fri, 20 November 2009 01:47 Go to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
Hi

Kindly provide us the SQL Command to find out the defination of dependent objects DDL of a table i.e. its indexes, constraints, grants,synonymns etc.

Kindly help.

Regards
Re: oracle Table and its dependent Object defination [message #431925 is a reply to message #431919] Fri, 20 November 2009 02:05 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

Use DBMS_METADATA package
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_metada.htm#ARPLS640
Re: oracle Table and its dependent Object defination [message #431926 is a reply to message #431919] Fri, 20 November 2009 02:05 Go to previous message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dbms_metadata

Regards
Michel
Previous Topic: How to view old information about dbms_jobs?
Next Topic: oracle client
Goto Forum:
  


Current Time: Wed Sep 28 02:26:02 CDT 2016

Total time taken to generate the page: 0.06122 seconds