Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I think there are some problems with object relational functionality in Oracle 11g (and some earlier versions). We have a purely relational mapping ready as it is easier to handle, but need to support some customers until they are ready to take this.

So I wondered if anybody knew whether I should be worried about duplicate entries in the all_dependencies table? Does Oracle use this for housekeeping or does it indicate the structure it is based on is wrong?

SELECT * 
from all_dependencies 
where referenced_name = 'POSTSET_TYP' 
order by owner, name, referenced_type, referenced_owner, referenced_name;

gives

OWNER       NAME            TYPE    REFERENCED_OWNER    REFERENCED_NAME REFERENCED_TYPE REFERENCED_LINK_NAME    DEPENDENCY_TYPE
CLEBARON    IMPRTJPS_TYP    TYPE    CLEBARON    POSTSET_TYP TYPE    <null>  HARD
CLEBARON    INPOSTSET_TYP   TYPE    CLEBARON    POSTSET_TYP TYPE    <null>  HARD
CLEBARON    LDGOPTPS_TYP    TYPE    CLEBARON    POSTSET_TYP TYPE    <null>  HARD
CLEBARON    MJPOSTINGSET_TYP    TYPE    CLEBARON    POSTSET_TYP TYPE    <null>  HARD
CLEBARON    POSTSET_ARR TYPE    CLEBARON    POSTSET_TYP TYPE    <null>  REF
EARLG       IMPRTJPS_TYP    TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       IMPRTJPS_TYP    TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       IMPRTJPS_TYP    TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       IMPRTJPS_TYP    TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       IMPRTJPS_TYP    TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       IMPRTJPS_TYP    TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       INPOSTSET_TYP   TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       INPOSTSET_TYP   TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       INPOSTSET_TYP   TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       INPOSTSET_TYP   TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       INPOSTSET_TYP   TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       INPOSTSET_TYP   TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       LDGOPTPS_TYP    TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       LDGOPTPS_TYP    TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       LDGOPTPS_TYP    TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       LDGOPTPS_TYP    TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       LDGOPTPS_TYP    TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       LDGOPTPS_TYP    TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       MJPOSTINGSET_TYP    TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       MJPOSTINGSET_TYP    TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       MJPOSTINGSET_TYP    TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       MJPOSTINGSET_TYP    TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       MJPOSTINGSET_TYP    TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       MJPOSTINGSET_TYP    TYPE    EARLG   POSTSET_TYP TYPE    <null>  HARD
EARLG       POSTSET_ARR TYPE    EARLG   POSTSET_TYP TYPE    <null>  REF
share|improve this question
    
Things can be dependant on each other. You need some CONNECT BY in your query. –  FreshPhilOfSO Dec 14 '13 at 0:39
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.