Re: Date of View created on DB

From: sybrandb@xxxxxxxxx
Date: 27 Feb 2006 05:45:00 -0800

user_|all_|dba_objects

dict has the catalog of dictionary views.
You can find any dictionary view by
select * from dict where table_name like '%<your query>%'

--
Sybrand Bakker
Senior Oracle DBA

.

References:
- Date of View created on DB
  - From: Daniel

Prev by Date: Currency sign ASCII value 164 ¤
Next by Date: Re: Currency sign ASCII value 164 ¤
Previous by thread: Date of View created on DB
Next by thread: Trigger needed
Index(es):
- Date
- Thread

Relevant Pages

Re: How to check database resource limit setup?
... Anyone know how to check resource_limt setup on 10Gr2? ... select * from dict where table_name like '%PROFILE%' ... Sybrand Bakker ... Senior Oracle DBA ...
(comp.databases.oracle.server)
Re: how to obtain grants for a specific user by reading systables
... You'd better query the table DICT for this type of question. ... Sybrand Bakker ... Senior Oracle DBA ...
(comp.databases.oracle.server)
Re: multiple block sizes ?
... In the future please refer to the DICT view, ... Sybrand Bakker ... Senior Oracle DBA ...
(comp.databases.oracle.server)
Re: Why is "shutdown abort", then backup bad
... Sybrand Bakker, Senior Oracle DBA wrote, amongst other things: ... How many flame wars? ... What, Mr. Bullshit, would ...
(comp.databases.oracle.server)
Re: exp and archive available.... recover table
... recoverd with all data by using log minor. ... Sybrand Bakker ... Senior Oracle DBA ... David Fitzjarrell ...
(comp.databases.oracle.server)