- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- why storage procedure turned invaild?
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-05-2002 10:46 PM
тАО08-05-2002 10:46 PM
why storage procedure turned invaild?
My oracle server (7.3.4 on dec 4.0D)is 7*24
, when i compile storage procedure , some other procedure will turn invaild and could not be compiled, sometimes I have to restart the server to compile them ,
such thing have comfused us for a long time ,why? how to solve it ?
Thanks
Sunny
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2002 07:56 AM
тАО08-06-2002 07:56 AM
Re: why storage procedure turned invaild?
To see if your item is pinned do:
select * from v$db_object_cache and look for your item with kept=yes to indicate pinning.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2002 09:21 AM
тАО08-06-2002 09:21 AM
Re: why storage procedure turned invaild?
select * dba_objects where status='INVALID'
Therefore when something goes wrong you check the new list of invalid objects.
To recompile if you have a big list you may want to automate the "recomp" procedure.
cf. attachment for some example
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2002 05:47 PM
тАО08-06-2002 05:47 PM
Re: why storage procedure turned invaild?
select 'alter procedure '||owner||'.'||object_name||' compile;' from dba_ob
jects
where object_type='PROCEDURE' and status='INVALID' and owner not in('SYS
','SYSTEM')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2002 05:49 PM
тАО08-06-2002 05:49 PM
Re: why storage procedure turned invaild?
how to unpin the pinned storage procedure?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2002 08:47 PM
тАО08-06-2002 08:47 PM
Re: why storage procedure turned invaild?
use
show errors
in SQL prompt
after complie error to see what is the exact error message.