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