DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.