DBA_OLDIMAGE_COLUMNS view tips

Oracle Tips by Burleson Consulting

DBA_OLDIMAGE_COLUMNS

<< Return to the index

Oracle 11g makes the following comments about the DBA_OLDIMAGE_COLUMNS table: "Gives all object tables and columns in old (8.0) image format"

Column description of the DBA_OLDIMAGE_COLUMNS view:

OWNER

Description of DBA_OLDIMAGE_COLUMNS.OWNER: "Owner of the table"

TABLE_NAME

Description of DBA_OLDIMAGE_COLUMNS.TABLE_NAME: "Name of the table"

COLUMN_NAME

Description of DBA_OLDIMAGE_COLUMNS.COLUMN_NAME: "Name of the top-level column"

DBA_OLDIMAGE_COLUMNS View Source

Oracle 11g's data dictionary defines the DBA_OLDIMAGE_COLUMNS view using the following source query:

select u.name, o.name,
decode(c.name, 'SYS_NC_ROWINFO$', 'OBJECT TABLE', c.name)
from sys.user$ u, sys."_CURRENT_EDITION_OBJ" o, sys.col$ c, sys.coltype$ t
where o.type# = 2 and /* show only tables */
o.owner# = u.user# and
o.obj# = c.obj# and
o.obj# = t.obj# and
c.intcol# = t.intcol# and
/* do not show attribute columns. If the attribute is in 8.0 image, that
means the whole column is in 8.0 image. Now, this will still show
top level ADT columns in an object table, which is redundant. */
bitand(c.property, 1) = 0 and
bitand(t.flags, 128) <> 0

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

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books