Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_ASSOCIATIONS All associations available to the user

Column ID Column name Data type Length Precision NULL Description
1OBJECT_OWNERVARCHAR230(null)NOwner of the object for which the association is being defined
2OBJECT_NAMEVARCHAR230(null)NObject name for which the association is being defined
3COLUMN_NAMEVARCHAR230(null)YColumn name in the object for which the association is being defined
4OBJECT_TYPEVARCHAR29(null)YSchema type of the object - column, type, package or function
5STATSTYPE_SCHEMAVARCHAR230(null)YOwner of the statistics type
6STATSTYPE_NAMEVARCHAR230(null)YName of Statistics type which contains the cost, selectivity or stats funcs
7DEF_SELECTIVITYNUMBER22(null)YDefault Selectivity if any of the object
8DEF_CPU_COSTNUMBER22(null)YDefault CPU cost if any of the object
9DEF_IO_COSTNUMBER22(null)YDefault I/O cost if any of the object
10DEF_NET_COSTNUMBER22(null)YDefault Networking cost if any of the object
11INTERFACE_VERSIONNUMBER22(null)YVersion number of Statistics type interface implemented
12MAINTENANCE_TYPEVARCHAR214(null)YWhether it is system managed or user managed

Index | Home | Forums

This page was created by oracleabc.com on Dec 31,2007 18:49:17
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here