Location of SYS.Packages
Does someone have a link or something for a list of *.sql scripts in $ORACLE_HOME/rdbms/admin (mostly) and which SYS.[PACKAGES] they contain (on UNIX)?
I often come across a missing SYS.PACKAGE and can't find it, even with a grep in the probable directories. An example being where the 'create or replace package' for LTADM, LT_CTX_PKG, or LTUTL are. (By the way, where ARE they? I know they're created using owminst.plb, but I still can't pinpoint the creation in the script.)
This would be very handy for me.
Last edited by Peer Jones; 06-09-2006 at 05:55 AM.
they should be in a form of a wrapped scripts(not intended to be read). probably called within a sql.
Not necessarily reside in $ORACLE_HOME/rdbms/admin but maybe
The package is contained in : $ORACLE_HOME/rdbms/admin/owmctxb.plb
It is a wrapped package, meaning it is encoded and not accessible for user viewing.
OK, thanks but even so, does someone know a link naming the *sql and *plb files and which packages they contain?
Click Here to Expand Forum to Full Width