|
-
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,
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
