Monday, May 30, 2011

Display all views? Easy.

Just Execute:

Select o.object_name, substr(o.status, 1, 1) status, o.last_ddl_time, o.object_id, o.created, o.owner
from       sys.DBA_OBJECTS o
where      o.object_type = 'VIEW'
and o.owner = 'SYS'
Result:

OBJECT_NAME
STATUS
LAST_DDL_TIME
OBJECT_ID
CREATED
OWNER
_utl$_lnc_ind_parts
V
3/30/2010 10:09
5373
3/30/2010 10:09
SYS
_utl$_lc_ind_subs
V
3/30/2010 10:09
5374
3/30/2010 10:09
SYS
_utl$_gp_ind_parts
V
3/30/2010 10:09
5372
3/30/2010 10:09
SYS
_utl$_gnp_ind
V
3/30/2010 10:09
5371
3/30/2010 10:09
SYS
_USER_REPL_NESTED_TABLE_NAMES
V
3/30/2010 10:10
6964
3/30/2010 10:10
SYS
_USER_QUEUE_SCHEDULES_COMPAT
V
3/30/2010 10:11
9258
3/30/2010 10:11
SYS

No comments:

Post a Comment