Home » SQL & PL/SQL » SQL & PL/SQL » dba_dependencies_columns (12.2.0.1.0)
dba_dependencies_columns [message #668050] Thu, 01 February 2018 12:29 Go to next message
Bill B
Messages: 1814
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 Go to previous messageGo to next message
Michel Cadot
Messages: 65971
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 Go to previous messageGo to next message
Bill B
Messages: 1814
Registered: December 2004
Senior Member
Bummer. Thanks. I will check out sys.dependency.d_attrs
Re: dba_dependencies_columns [message #668055 is a reply to message #668054] Thu, 01 February 2018 14:42 Go to previous messageGo to next message
Bill B
Messages: 1814
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/
Re: dba_dependencies_columns [message #668058 is a reply to message #668055] Fri, 02 February 2018 06:46 Go to previous messageGo to next message
EdStevens
Messages: 1005
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".
Re: dba_dependencies_columns [message #668060 is a reply to message #668058] Fri, 02 February 2018 07:48 Go to previous message
Bill B
Messages: 1814
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:
  


Current Time: Sun Nov 18 21:06:17 CST 2018