| |
 |
|
DBA_CATALOG view tips
Oracle Tips by Burleson Consulting |
DBA_CATALOG
<< Return to the index
Oracle 11g makes the following comments about the DBA_CATALOG table: "All database Tables, Views, Synonyms, Sequences"
Related notes on DBA_CATALOG:
Column description of the DBA_CATALOG view:OWNERDescription of DBA_CATALOG.OWNER: "Owner of the object" TABLE_NAMEDescription of DBA_CATALOG.TABLE_NAME: "Name of the object" TABLE_TYPEDescription of DBA_CATALOG.TABLE_TYPE: "Type of the object"
DBA_CATALOG View SourceOracle 11g's data dictionary defines the DBA_CATALOG view using the following source query:
select u.name, o.name,
decode(o.type#, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER',
4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 'UNDEFINED')
from sys.user$ u, sys."_CURRENT_EDITION_OBJ" o
where o.owner# = u.user#
and o.linkname is null
and ((o.type# in (4, 5, 6))
or
(o.type# = 2 /* tables, excluding iot - overflow and nested tables */
and
not exists (select null
from sys.tab$ t
where t.obj# = o.obj#
and (bitand(t.property, 512) = 512 or
bitand(t.property, 8192) = 8192))))
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
