[adowla]

Does anybody have an OTM ERD diagram?

Thanks,
Arham

[ianlo]

Hi Arham,

It should be available as part of the installation. You can find it in OTM_HOME\docs\database

[rkuruba]

Where is this ERD diagram in OTM 5.5 CU3 I can't find it. Also the data dictionary. Can you anyone provide me this information?

[chrisplough]

Hello

I can't post this directly, as it is Oracle's proprietary information. I just double-checked a CU3 installation and it appears to still be available under OTM_HOME/docs/database/data_dictionary_diagrams.zip

Thanks,
Chris

[naveengupta4s]

You can try running the file path placed in the below path to access the OTM ERD Diagrams:

<OTM Install Directory>\ docs\database\data_dictionary_diagrams\index.htm

Regards,
Naveen

[rkuruba]

We found it. It is under installation CD Part1 for Solaris.

otm/Part1/database
$ ls
data_dictionary.zip datadictionaryreadme.txt
data_dictionary_diagrams.zip structural_changes.pdf

Thanks Guys.
RK.

[chrisplough]

RK,

Glad you found it! The data_dictionary.zip file contains an HTML version of the DB schema and the data_dictionary_diagrams.zip contains the ERD Diagrams.

Also, for anyone else - after installation, these files are located under the directory we referenced earlier ($OTM_HOME/docs/database)

--Chris