skip to main
|
skip to sidebar
Tech Bytes
Tuesday, October 27, 2009
Oracle Invalid Objects
Here is a quick query for Oracle users to identify all invalid objects:
SELECT
owner,object_name,object_type
FROM
dba_objects
WHERE
status=
'INVALID'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Followers
Blog Archive
►
2014
(2)
►
April
(2)
►
2010
(2)
►
February
(2)
▼
2009
(17)
►
December
(3)
►
November
(2)
▼
October
(4)
Oracle Invalid Objects
Deleting Objects from a Schema in Oracle
Useful SQL commands
Tech Jokes
►
September
(1)
►
August
(4)
►
July
(3)
About Me
Bharat Joshi
View my complete profile
No comments:
Post a Comment