| Invalid objects [message #167044] |
Tue, 11 April 2006 00:10  |
vandana173
Messages: 7
Registered: August 2005
Location: india
|
Junior Member |
|
|
Hi,
We have oracle server 9i 32 bit installed. We are having around 43 schemas in a database & we have created synonyms for all the objets & they are having public access. But whenever we compiles the objects in all the schemas, after sometime some objects become invalid automatically. What should be the reason behind this? How the objects are getting invaid automatically.
Please reply ASAP.
Vandana
|
|
|
|
| Re: Invalid objects [message #167084 is a reply to message #167044] |
Tue, 11 April 2006 04:55  |
madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india
|
Member |
|
|
invalidation is quite common whenver there is a change in the base objects , normally they will get validated auomatically if there is no error in the base objects
Thanks
Madhu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
