OraFAQ Forum: SQL & PL/SQL » dba_dependencies

Home » SQL & PL/SQL » SQL & PL/SQL » dba_dependencies_columns (12.2.0.1.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dba_dependencies_columns [message #668050]

Thu, 01 February 2018 12:29

Bill B
Messages: 1971
Registered: December 2004

Senior Member

Back in oracle 11g, Oracle were talking about adding a view to show dependencies down to the column level (dba_dependencies_columns). Does anyone know what ever happened to this view?

[Updated on: Thu, 01 February 2018 12:46]

Report message to a moderator

Re: dba_dependencies_columns [message #668053 is a reply to message #668050]

Thu, 01 February 2018 14:27

Michel Cadot
Messages: 68510
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I don't think Oracle ever talk about this view, I remember some (out of Oracle) talked about how nice it would be to have this view. Smile

Fine-grained dependency was introduced in 11g recorded bit wised in sys.dependency.d_attrs column.

[Edit: missing word]

[Updated on: Thu, 01 February 2018 15:09]

Report message to a moderator

Re: dba_dependencies_columns [message #668054 is a reply to message #668053]

Thu, 01 February 2018 14:30

Bill B
Messages: 1971
Registered: December 2004

Senior Member

Bummer. Thanks. I will check out sys.dependency.d_attrs

Report message to a moderator

Re: dba_dependencies_columns [message #668055 is a reply to message #668054]

Thu, 01 February 2018 14:42

Bill B
Messages: 1971
Registered: December 2004

Senior Member

While searching for information on the table I came across a script that actually builds a functioning DBA_DEPENDENCY_COLUMNS view. see the following url

https://ronaldsoracle.wordpress.com/2013/08/23/querying-column-dependencies-using-fine-grained-dependecies/

Report message to a moderator

Re: dba_dependencies_columns [message #668058 is a reply to message #668055]

Fri, 02 February 2018 06:46

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

Of course the problem with that view is that it is a customer-create view that depends on undocumented data dictionary tables. Since it was create at 11g it can be assumed to work with 11g but, in spite of the author's comment "needless to say this script will only work on Oracle 11g or up"(emphasis mine) there is no guarantee at all that it will work with "and up".

Report message to a moderator

Re: dba_dependencies_columns [message #668060 is a reply to message #668058]

Fri, 02 February 2018 07:48

Bill B
Messages: 1971
Registered: December 2004

Senior Member

That is true, but I am currently on 12.2 and it is working correctly. So until oracle gets off their backside and makes a view for use by their customers I will use this one

[Updated on: Fri, 02 February 2018 07:50]

Report message to a moderator

Previous Topic:	Websocket connection through Oracle PL SQL
Next Topic:	recursive query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Oct 04 05:19:26 CDT 2023