Oracle DB 11g Express Edition Find directory home path in Windows 7
WDMar 31 2012 — edited Mar 31 2012Hello,
I am working through a PL/SQL Programming book and I am on PROGRAM UNIT DEPENDENCIES. As I work through the examples it asks me to use the Dependency Tree Utility by running this script in SQL*Plus: @<path to Oracle Home directory>\rdbms\utldtree
However, no matter where I look on my computer (Win7 Home) I cannot figure out the directory path. I looked elsewhere and it was suggested that Windows stores the directory in the registry. I went to regedit and followed Hkey_Local_Machine\Software\Oracle....and found 'c:\oraclexe\app\oracle\product\l11.2.0\server'
I tried that as the directory path, but no luck. Plus I cannot even find any file folders for the DB that contains 'rdbms'.
So my question is, is there a directory HOME or BASE path in windows 7 for Oracle database 11g Express Edition and or does the 11g Express Edition have the utldtree.sql file somewhere?
Thanks in advance for any help,
Warren