| ALL_OBJECTS and ORACLE9i [message #64495] |
Wed, 02 February 2005 06:57  |
Sergio Bonfim
Messages: 2
Registered: February 2005
|
Junior Member |
|
|
Hi Fellow,
About this table, ALL_OBJECTS , that describes all objects accessible to the user, I want to know the
signification of the STATUS column, because I found that some table got "VALID" and another "INVALID" status.
Please, can you help me on this explanation. I was trying to find more explanations on oracle technical manuals but I can't find nothing.
Thanks in Advance,
Sergio
|
|
|
|
| Re: ALL_OBJECTS and ORACLE9i [message #64496 is a reply to message #64495] |
Wed, 02 February 2005 07:52  |
Tads
Messages: 10
Registered: February 2005
|
Junior Member |
|
|
This status can be about, for example, a view that
was created based on a table and this table was dropped, so the view references an object that does not exists and so it´s INVALID.
|
|
|
|
| Re: ALL_OBJECTS and ORACLE9i [message #64497 is a reply to message #64496] |
Wed, 02 February 2005 09:25 |
Sergio Bonfim
Messages: 2
Registered: February 2005
|
Junior Member |
|
|
Thanks for your explanation.
But I found the follow:
SYS DBA_DDL_LOCKS View 17-06-04 17-06-04 invalid
SYS DBA_KGLLOCK View 17-06-04 17-06-04 invalid
SYS DBA_LOCK_INTERNAL View 17-06-04 17-06-04 invalid
and I see the same on some user objects.
What do you think?
Sergio
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
