RE: Oracle 11i Data Model

  • From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
  • To: chaganti.suresh@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 2 Aug 2007 07:27:06 -0500

If the constraints are actually created, you can always look at
dba_constraints and dba_cons_columns.  Otherwise, data dictionary
development is left as an exercise for the developer.

 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Suresh Chaganti
Sent: Wednesday, August 01, 2007 4:40 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Oracle 11i Data Model

 

After attending Siebel training some time back, this question came up.

In siebel, they have tools in which all the realtions between tables
including referential integrity is documented and queried. I understand
this is pretty much same is peoplesoft as well. 



Oracle 11i model doesn have PK/FK defined for majority of the tables.
For example, PO_header_id in po_vendors_all is NOT a primary key, but a
check constraint with not null condition. Also there is no PK/FK between
po_headers_all and po_lines_all, as defined at the DB level. 

For Oracle, I know there are TRMs and I use them a lot. But to my
knowledge, there is no "data dictionary" about application tables that
would help use derive realtions by querying with in the application. 

Is there an approach / method to derive relationships instead of looking
at ERDs in TRMs? I guess I am asking is there something equivalent to
what Siebel/peoplesoft provide in this area

Thanks in advance 




------------------------------------------------------------------------------
NOTICE:  This electronic mail message and any attached files are confidential.  
The information is exclusively for the use of the individual or entity intended 
as the recipient.  If you are not the intended recipient, any use, copying, 
printing, reviewing, retention, disclosure, distribution or forwarding of the 
message or any attached file is not authorized and is strictly prohibited.  If 
you have received this electronic mail message in error, please advise the 
sender by reply electronic mail immediately and permanently delete the original 
transmission, any attachments and any copies of this message from your computer 
system. Thank you.

==============================================================================

Other related posts: