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
    Posts
    118

    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.

    Thanks
    Peer
    Last edited by Peer Jones; 06-09-2006 at 04:55 AM.

  2. #2
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    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
    $ORACLE_HOME/.../admin/
    ---------------

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