Home » SQL & PL/SQL » SQL & PL/SQL » How to find a remote dependencies of a database object
How to find a remote dependencies of a database object [message #443669] Tue, 16 February 2010 22:18 Go to next message
vikram1780
Messages: 222
Registered: January 2007
Location: Bangalore
Senior Member

Hi,

As a part of requirement need to clean up some of database objects from database. Before cleaning up need to check for dependencies with in database and also on remote database.

Is there any data dcitionary in oracle which proivides information about remote dependencies.

Any other way to get a list of remote dependencies other then manual checking.

Any help really appreciated

Thanks in advance
Re: How to find a remote dependencies of a database object [message #443671 is a reply to message #443669] Tue, 16 February 2010 22:25 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
unwilling or incapable to follow Posting Guidelines?

>Any other way to get a list of remote dependencies other then manual checking.

post example of how to do "manual checking".
Exactly what are you checking for?
Re: How to find a remote dependencies of a database object [message #443674 is a reply to message #443669] Tue, 16 February 2010 22:48 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
http://www.praetoriate.com/data_dictionary/dd_all_dependencies.htm

Your post i guess
http://forums.oracle.com/forums/thread.jspa?threadID=1030319&tstart=0

http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/dependencies.htm

Good luck
sriram Smile
Re: How to find a remote dependencies of a database object [message #443675 is a reply to message #443674] Tue, 16 February 2010 22:51 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
I just re read your post...

Quote:
Any other way to get a list of remote dependencies other then manual checking.


Define your Manual checking.

Going through the views Oracle provided...You are manuall checking the views Not the dependents..Oracle will do the JOb for you...

YOu just Query them.

Sriram Smile
Previous Topic: Query for scenario
Next Topic: Alternative Of Soundex Function
Goto Forum:
  


Current Time: Sun Dec 04 04:24:20 CST 2016

Total time taken to generate the page: 0.11181 seconds