The Tech Findings of R
Showing posts with label
System Tables
.
Show all posts
Showing posts with label
System Tables
.
Show all posts
Monday, August 23, 2010
How do you find the invalid objects in your schema?
SELECT
object_name
,
object_type
,
created
,
last_ddl_time
,
status
FROM
user_objects
WHERE
status !
=
'VALID'
Older Posts
Home
Subscribe to:
Posts (Atom)