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

Thread: Package To Compile Objects In The Database

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    Package To Compile Objects In The Database

    Hi all,

    Can someone please tell me or show me the docs of the package to compile objects in the database??

    Thanks

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    @?/rdbms/admin/utlrp.sql

  3. #3
    Join Date
    Sep 2002
    Posts
    411
    Pando,

    Thanks for your quick response and I am sorry about not having my question more clear. What I mean was DBMS_UTILITY.compile_schema.

    I like to put this in the DBMS_JOB so it can be run once a week.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Personally, I haven't had very good luck with COMPILE_SCHEMA in databases where there were heavy dependancies. Your mileage may vary...
    Jeff Hunter

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