Location of SYS.Packages
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Location of SYS.Packages

  1. #1
    Join Date
    Nov 2001

    Location of SYS.Packages

    Hi Everyone,

    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 04:55 AM.

  2. #2
    Join Date
    Sep 2001
    Makati, Philippines
    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

  3. #3
    Join Date
    Jun 2006
    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.

  4. #4
    Join Date
    Nov 2001
    OK, thanks but even so, does someone know a link naming the *sql and *plb files and which packages they contain?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width