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

Report message to a moderator

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

Report message to a moderator

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: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dbms_metadata

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 00:13:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.