DBA_PENDING_CONV_TABLES view tips

Oracle Tips by Burleson Consulting

DBA_PENDING_CONV_TABLES

<< Return to the index

Oracle 11g makes the following comments about the DBA_PENDING_CONV_TABLES table: "All tables which are not upgraded to the latest type version in the database"

Related notes on DBA_PENDING_CONV_TABLES:

Oracle DBA View List

Column description of the DBA_PENDING_CONV_TABLES view:

OWNER

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

TABLE_NAME

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

DBA_PENDING_CONV_TABLES View Source

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

select u.name, o.name
from sys.obj$ o, user$ u
where o.type# = 2 and o.status = 5
and bitand(o.flags, 4096) = 4096 /* type evolved flg */
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

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books