Invalid object
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Invalid object

  1. #1
    Join Date
    Mar 2008
    Posts
    140

    Invalid object

    Hi, how to compile Invalid objects in database through oracle with using third party tool like toad. Is there any dbms_package for performing this task.

    thanks,

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    What kind of invalid object?

    Is it a storedproc?

    ALTER PROCEDURE schema.procname COMPILE
    /

    You can easily research proper syntax for packages, package bodies, triggers and functions.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    You can create a global script some thing like below. You will get the list of all invalid objects.

    Code:
    select 'alter '||decode(object_type,'PACKAGE BODY','PACKAGE',object_type)||' '||owner||'.'||object_name||' COMPILE '||decode(object_type,'PACKAGE BODY','BODY')||';'from dba_objects where status <> 'VALID' order by owner, object_type
    /
    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

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