I'm not a DBA but I am a (mostly!) competent SQL report writer. Can I trouble you DBAs for some pro-knowledge, please?
I can connect SQL Developer to Oracle XE's data dictionary without any problem, i.e. view the information of the data dictionary as an ERD within SQL Developer that shows the tables belonging to HR and the the relationships between these tables expressed as links between the PKs and FKs of the individual tables.
However, when I import the data dictionary from my workplace's 11g Oracle DB into SQL Developer, it brings back all the tables of the schema I'm pointing SQL Developer at but doesn't show the relationships between these tables - i.e. no links between the PKs/FKs of the tables belonging to the schema.
Is this feature something that has to be written into the ERD manually, or should table relationship information be available as part of the tables that make up the data dictionary?
USER_CONSTRAINTS
will show you information on constraints that your schema user owns.ALL_CONSTRAINTS
will show you information about constraints that you have the appropriate permissions in place to see/use.DBA_CONSTRAINTS
will show you all constraints.