| |
 |
|
DBA_TYPE_VERSIONS view tips
Oracle Tips by Burleson Consulting |
DBA_TYPE_VERSIONS
<< Return to the index
Oracle 11g makes the following comments about the DBA_TYPE_VERSIONS table: "Description of each type version in the database"
Related notes on DBA_TYPE_VERSIONS:
Column description of the DBA_TYPE_VERSIONS view:OWNERDescription of DBA_TYPE_VERSIONS.OWNER: "Owner of the type" TYPE_NAMEDescription of DBA_TYPE_VERSIONS.TYPE_NAME: "Name of the type" VERSION#Description of DBA_TYPE_VERSIONS.VERSION#: "Internal version number of the type" TYPECODEDescription of DBA_TYPE_VERSIONS.TYPECODE: "Typecode of the type" STATUSDescription of DBA_TYPE_VERSIONS.STATUS: "Status of the type" LINEDescription of DBA_TYPE_VERSIONS.LINE: "Line number of the type's spec" TEXTDescription of DBA_TYPE_VERSIONS.TEXT: "Text of the type's spec" HASHCODEDescription of DBA_TYPE_VERSIONS.HASHCODE: "Hashcode of the type"
DBA_TYPE_VERSIONS View SourceOracle 11g's data dictionary defines the DBA_TYPE_VERSIONS view using the following source query:
select u.name, o.name, t.version#,
decode(t.typecode, 108, 'OBJECT',
122, 'COLLECTION',
o.name),
decode(o.status, 0, 'N/A', 1, 'VALID', 'INVALID'),
s.line, s.source,
t.hashcode
from sys."_CURRENT_EDITION_OBJ" o, sys.source$ s, sys.type$ t, user$ u
where o.obj# = s.obj# and o.oid$ = t.tvoid and o.type# = 13
and o.owner# = u.user#
 |
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
|
|
