Database Administration (MOSC)

MOSC Banner

Script for Compiling Invalid Objects

aschorr
aschorr Posts: 7 Green Ribbon

Comments

  • user649511
    user649511 Posts: 1,484 Silver Trophy
    You could also just log in as sys and do 'exec utl_recomp.recomp_serial'. 
  • Mark D Powell
    Mark D Powell Posts: 17,366 Rubellite
    You could also just log in as sys and do 'exec utl_recomp.recomp_serial'. 
    I would rather the OP just use utlrp as a sysdba.  Oracle provides and recommends the use of this script. 

    HTH -- Mark D Powell --

    HTH -- Mark D Powell --

  • aschorr
    aschorr Posts: 7 Green Ribbon
    I would rather the OP just use utlrp as a sysdba.  Oracle provides and recommends the use of this script. 

    HTH -- Mark D Powell --

     Hello.

    Since I have had issues with using utlrp in the past, I choose to go with something that consistently works.

  • user7443914
    user7443914 Posts: 94 Blue Ribbon
     I don't know, but in your script you may take into account the case of
      alter package <object_name> view;
     
  • shrikant apune
    shrikant apune Posts: 675 Silver Badge
    edited Nov 12, 2009 8:51PM
     I don't know, but in your script you may take into account the case of
      alter package <object_name> view;
     
    Hi,

    alter package <package_name> compile; (package specification)
    alter package <package_name> compile body; (package body)

    both should have to take care .

    Thanks,

    Shrikant  

  • user7443914
    user7443914 Posts: 94 Blue Ribbon
    Hi,

    alter package <package_name> compile; (package specification)
    alter package <package_name> compile body; (package body)

    both should have to take care .

    Thanks,

    Shrikant  

     Hi,
    his script looks like that it already takes into account this two cases. But "view" is missing.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center