Home » SQL & PL/SQL » SQL & PL/SQL » Dependent Objects recursively (Oracle 11.2.0.3)
Dependent Objects recursively [message #663308] Mon, 29 May 2017 12:05 Go to next message
pointers
Messages: 451
Registered: May 2008
Senior Member
Hi,

I am trying to pull DDL's of all the components of a given object using DBA_DEPENDENCIES and then DBMS_METADATA.GET_DDL

But is there a built in method to pull all the dependent objects recursively.

Thank you in advance.

Regards,
Pointers
Re: Dependent Objects recursively [message #663309 is a reply to message #663308] Mon, 29 May 2017 12:14 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
some, many, most Professional IT group keep all application code, including DDL, in source code repository; such as subversion.

FUNCTION GET_DEPENDENT_DDL RETURNS CLOB
Re: Dependent Objects recursively [message #663312 is a reply to message #663308] Mon, 29 May 2017 13:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

See the following scripts:
To get the tree list of the objects depending of an object
To get the tree list of the objects on which an object depends

Re: Dependent Objects recursively [message #663318 is a reply to message #663312] Mon, 29 May 2017 21:06 Go to previous messageGo to next message
pointers
Messages: 451
Registered: May 2008
Senior Member
Thank you Micheal.

Unfortunately I don't have an account on the mentioned website.

Could you please paste the content.

Regards,
Pointers
Re: Dependent Objects recursively [message #663321 is a reply to message #663318] Tue, 30 May 2017 00:09 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Just create one.

Previous Topic: Using loop with a variable table name
Next Topic: Armstrong numbers
Goto Forum:
  


Current Time: Fri Mar 29 06:59:41 CDT 2024