Oracle Schema Collections

 

The Microsoft .NET Framework Data Provider for Oracle supports the following specific schema collections in addition to the common schema collections:

  • Columns

  • Indexes

  • IndexColumns

  • Procedures

  • Sequences

  • Synonyms

  • Tables

  • Users

  • Views

  • Functions

  • Packages

  • PackageBodies

  • Arguments

  • UniqueKeys

  • PrimaryKeys

  • ForeignKeys

  • ForeignKeyColumns

  • ProcedureParameters

ColumnNameDataTypeDescription
OWNERStringOwner of the table, view or cluster.
TABLE_NAMEStringTable, view, or cluster name.
COLUMN_NAMEStringColumn name.
IDDecimalSequence number of the column as created.
DATATYPEStringDatatype of the column.
LENGTHDecimalLength of the column in bytes.
PRECISIONDecimalDecimal precision for NUMBER datatype; binary precision for FLOAT datatype, null for all other datatypes.
SCALEDecimalDigits to right of decimal point in a number.
NULLABLEStringSpecifies whether a column allows NULLs. Value is N if there is a NOT NULL constraint on the column or if the column is part of a PRIMARY KEY.
ColumnNameDataTypeDescription
OWNERStringOwner of the index
INDEX_NAMEStringName of the index.
INDEX_TYPEStringType of index (NORMAL, BITMAP, FUNCTION-BASED NORMAL, FUNCTION-BASED BITMAP, or DOMAIN).
TABLE_OWNERStringOwner of the indexed object.
TABLE_NAMEStringName of the indexed object.
TABLE_TYPEStringType of the indexed object (for example, TABLE, CLUSTER).
UNIQUENESSStringWhether the index is UNIQUE or NONUNIQUE.
COMPRESSIONStringWhether the index is ENABLED or DISABLED.
PREFIX_LENGTHDecimalNumber of columns in the prefix of the compression key.
TABLESPACE_NAMEStringName of the tablespace containing the index.
INI_TRANSDecimalInitial number of transactions.
MAX_TRANSDecimalMaximum number of transactions.
INITIAL_EXTENTDecimalSize of the initial extent.
NEXT_EXTENTDecimalSize of secondary extents.
MIN_EXTENTSDecimalMinimum number of extents allowed in the segment.
MAX_EXTENTSDecimalMaximum number of extents allowed in the segment.
PCT_INCREASEDecimalPercentage increase in extent size.
PCT_THRESHOLDDecimalThreshold percentage of block space allowed per index entry.
INCLUDE_COLUMNDecimalColumn ID of the last column to be included in index-organized table primary key (non-overflow) index. This column maps to the COLUMN_ID column of the *_TAB_COLUMNS data dictionary views.
FREELISTSDecimalNumber of process freelists allocated to this segment.
FREELIST_GROUPSDecimalNumber of freelist groups allocated to this segment.
PCT_FREEDecimalMinimum percentage of free space in a block.
LOGGINGStringLogging information.
BLEVELDecimalB*-Tree level: depth of the index from its root block to its leaf blocks. A depth of 0 indicates that the root block and leaf block are the same.
LEAF_BLOCKSDecimalNumber of leaf blocks in the index
DISTINCT_KEYSDecimalNumber of distinct indexed values. For indexes that enforce UNIQUE and PRIMARY KEY constraints, this value is the same as the number of rows in the table (USER_TABLES.NUM_ROWS).
AVG_LEAF_BLOCKS_PER_KEYDecimalAverage number of leaf blocks in which each distinct value in the index appears rounded to the nearest integer. For indexes that enforce UNIQUE and PRIMARY KEY constraints, this value is always 1.
AVG_DATA_BLOCKS_PER_KEYDecimalAverage number of data blocks in the table that are pointed to by a distinct value in the index rounded to the nearest integer. This statistic is the average number of data blocks that contain rows that contain a given value for the indexed columns.
CLUSTERING_FACTORDecimalIndicates the amount of order of the rows in the table based on the values of the index.
STATUSStringWhether a nonpartitioned index is VALID or UNUSABLE.
NUM_ROWSDecimalNumber of rows in the index.
SAMPLE_SIZEDecimalSize of the sample used to analyze the index.
LAST_ANALYZEDDateTimeDate on which this index was most recently analyzed.
DEGREEStringNumber of threads per instance for scanning the index.
INSTANCESStringNumber of instances across which the indexes to be scanned.
PARTITIONEDStringWhether this index is partitioned (YES | NO).
TEMPORARYStringWhether the index is on a temporary table.
GENERATEDStringWhether the name of the index is system generated (Y|N).
SECONDARYStringWhether the index is a secondary object created by the ODCIIndexCreate method of the Oracle9i Data Cartridge (Y|N).
BUFFER_POOLStringName of the default buffer pool to be used for the index blocks.
USER_STATSStringWhether the statistics were entered directly by the user.
DURATIONStringIndicates the duration of a temporary table: 1)SYS$SESSION: the rows are preserved for the duration of the session, 2) SYS$TRANSACTION: the rows are deleted after COMMIT, 3) Null for permanent Table.
PCT_DIRECT_ACCESSDecimalFor a secondary index on an index-organized table, the percentage of rows with VALID guess
ITYP_OWNERStringFor a domain index, the owner of the indextype.
ITYP_NAMEStringFor a domain index, the name of the indextype.
PARAMETERSStringFor a domain index, the parameter string.
GLOBAL_STATSStringFor partitioned indexes, indicates whether statistics were collected by analyzing index as a whole (YES) or were estimated from statistics on underlying index partitions and subpartitions (NO).
DOMIDX_STATUSStringReflects the status of the domain index. NULL: the specified index is not a domain index. VALID: the index is a valid domain index. IDXTYP_INVLD: the index type of this domain index is invalid.
DOMIDX_OPSTATUSStringReflects the status of an operation that was performed on a domain index: NULL: the specified index is not a domain index. VALID: the operation performed without errors. FAILED: the operation failed with an error.
FUNCIDX_STATUSStringIndicates the status of a function-based index: NULL: this is not a function-based index, ENABLED: the function-based index is enabled, DISABLED: the function-based index is disabled.
JOIN_INDEXStringIndicates whether this is a join index or not.
ColumnNameDataTypeDescription
INDEX_OWNERStringOwner of the index.
INDEX_NAMEStringName of the index.
TABLE_OWNERStringOwner of the table or cluster.
TABLE_NAMEStringName of the table or cluster.
COLUMN_NAMEStringColumn name or attribute of object type column.
COLUMN_POSITIONDecimalPosition of column or attribute within the index.
COLUMN_LENGTHDecimalIndexed length of the column.
CHAR_LENGTHDecimalMaximum codepoint length of the column.
DESCENDStringWhether the column is sorted in descending order.
ColumnNameDataTypeDescription
OWNERStringOwner of the object.
OBJECT_NAMEStringName of the object.
SUBOBJECT_NAMEStringName of the subobject (for example, partition).
OBJECT_IDDecimalDictionary object number of the object.
DATA_OBJECT_IDDecimalDictionary object number of the segment that contains the object.
LAST_DDL_TIMEDateTimeTimestamp for the last modification of the object resulting from a DDL command (including grants and revokes).
TIMESTAMPStringTimestamp for the specification of the object (character data).
STATUSStringStatus of the object (VALID, INVALID, or N/A).
TEMPORARYStringWhether the object is temporary (the current session can see only data that it placed in this object itself).
GENERATEDStringWas the name of this object system generated? (Y | N).
SECONDARYStringWhether this is a secondary object created by the ODCIIndexCreate method of the Oracle9i Data Cartridge (Y | N).
CREATEDDateTimeThe date the object was created.
ColumnNameDataTypeDescription
SEQUENCE_OWNERStringName of the owner of the sequence.
SEQUENCE_NAMEStringSequence name.
MIN_VALUEDecimalMinimum value of the sequence.
MAX_VALUEDecimalMaximum value of the sequence.
INCREMENT_BYDecimalValue by which sequence is incremented.
CYCLE_FLAGStringDoes sequence wrap around on reaching limit.
ORDER_FLAGStringAre sequence numbers generated in order.
CACHE_SIZEDecimalNumber of sequence numbers to cache.
LAST_NUMBERDecimalLast sequence number written to disk. If a sequence uses caching, the number written to disk is the last number placed in the sequence cache. This number is likely to be greater than the last sequence number that was used.
ColumnNameDataTypeDescription
OWNERStringOwner of the synonym.
SYNONYM_NAMEStringName of the synonym.
TABLE_OWNERStringOwner of the object referenced by the synonym.
TABLE_NAMEStringName of the object referenced by the synonym.
DB_LINKStringName of the database link referenced, if any.
ColumnNameDataTypeDescription
OWNERStringOwner of the table.
TABLE_NAMEStringName of the table.
TYPEStringType of table.
ColumnNameDataTypeDescription
NAMEStringName of the user.
IDDecimalID number of the user.
CREATEDATEDateTimeUser creation date.
ColumnNameDataTypeDescription
OWNERStringOwner of the view.
VIEW_NAMEStringName of the view.
TEXT_LENGTHDecimalLength of the view text.
TEXTStringView text.
TYPE_TEXT_LENGTHDecimalLength of the type clause of the typed view.
TYPE_TEXTStringType clause of the typed view.
OID_TEXT_LENGTHDecimalLength of the WITH OID clause of the typed view.
OID_TEXTStringWITH OID clause of the typed view.
VIEW_TYPE_OWNERStringOwner of the type of the view if the view is a typed view.
VIEW_TYPEStringType of the view if the view is a typed view.
SUPERVIEW_NAMEStringName of the superview.
ColumnNameDataTypeDescription
OWNERStringOwner of the object.
OBJECT_NAMEStringName of the object.
SUBOBJECT_NAMEStringName of the subobject (for example, partition).
OBJECT_IDDecimalDictionary object number of the object.
DATA_OBJECT_IDDecimalDictionary object number of the segment that contains the object.
OBJECT_TYPEStringType of the object.
CREATEDDateTimeThe date the object was created.
LAST_DDL_TIMEDateTimeTimestamp for the last modification of the object resulting from a DDL command (including grants and revokes).
TIMESTAMPStringTimestamp for the specification of the object (character data)
STATUSStringStatus of the object (VALID, INVALID, or N/A).
TEMPORARYStringWhether the object is temporary (the current session can see only data that it placed in this object itself).
GENERATEDStringWas the name of this object system generated? (Y | N).
SECONDARYStringWhether this is a secondary object created by the ODCIIndexCreate method of the Oracle9i Data Cartridge (Y | N).
ColumnNameDataTypeDescription
OWNERStringOwner of the object.
OBJECT_NAMEStringName of the object.
SUBOBJECT_NAMEStringName of the subobject (for example, partition).
OBJECT_IDDecimalDictionary object number of the object.
DATA_OBJECT_IDDecimalDictionary object number of the segment that contains the object.
LAST_DDL_TIMEDateTimeTimestamp for the last modification of the object resulting from a DDL command (including grants and revokes).
TIMESTAMPStringTimestamp for the specification of the object (character data).
STATUSStringStatus of the object (VALID, INVALID, or N/A).
TEMPORARYStringWhether the object is temporary (the current session can see only data that it placed in this object itself).
GENERATEDStringWas the name of this object system generated? (Y | N).
SECONDARYStringWhether this is a secondary object created by the ODCIIndexCreate method of the Oracle9i Data Cartridge (Y | N).
CREATEDDateTimeThe date the object was created.
ColumnNameDataTypeDescription
OWNERStringOwner of the object.
OBJECT_NAMEStringName of the object.
SUBOBJECT_NAMEStringName of the subobject (for example, partition).
OBJECT_IDDecimalDictionary object number of the object.
DATA_OBJECT_IDDecimalDictionary object number of the segment that contains the object.
LAST_DDL_TIMEDateTimeTimestamp for the last modification of the object resulting from a DDL command (including grants and revokes).
TIMESTAMPStringTimestamp for the specification of the object (character data).
STATUSStringStatus of the object (VALID, INVALID, or N/A).
TEMPORARYStringWhether the object is temporary (the current session can see only data that it placed in this object itself).
GENERATEDStringWas the name of this object system generated? (Y | N).
SECONDARYStringWhether this is a secondary object created by the ODCIIndexCreate method of the Oracle9i Data Cartridge (Y | N).
CREATEDDateTimeThe date the object was created.
ColumnNameDataTypeDescription
OWNERStringName of the owner of the object.
PACKAGE_NAMEStringPackage name.
OBJECT_NAMEStringName of the procedure or function.
ARGUMENT_NAMEStringName of the argument.
POSITIONDecimalPosition in argument list, or NULL for function return value.
SEQUENCEDecimalArgument sequence, including all nesting levels.
DEFAULT_VALUEStringDefault value for the argument.
DEFAULT_LENGTHDecimalLength of default value for the argument.
IN_OUTStringArgument direction (IN, OUT, or IN/OUT).
DATA_LENGTHDecimalLength of the column in bytes.
DATA_PRECISIONDecimalLength in decimal digits (NUMBER) or binary digits (FLOAT).
DATA_SCALEDecimalDigits to right of decimal point in a number.
DATA_TYPEStringData type of the argument.
ColumnNameDataTypeDescription
OWNERStringOwner of the constraint definition.
CONSTRAINT_NAMEStringName of the constraint definition.
TABLE_NAMEStringName associated with the table (or view) with constraint definition.
SEARCH_CONDITIONStringText of search condition for a check constraint.
R_OWNERStringOwner of table referred to in a referential constraint.
R_CONSTRAINT_NAMEStringName of the unique constraint definition for referenced table.
DELETE_RULEStringDelete rule for a referential constraint (CASCADE or NO ACTION).
STATUSStringEnforcement status of constraint (ENABLED or DISABLED).
DEFERRABLEStringWhether the constraint is deferrable.
VALIDATEDStringWhether all data obeys the constraint (VALIDATED or NOT VALIDATED).
GENERATEDStringWhether the name of the constraint is user or system generated.
BADStringA YES value indicates that this constraint specifies a century in an ambiguous manner. To avoid errors resulting from this ambiguity, rewrite the constraint using the TO_DATE function with a four-digit year.
RELYStringWhether an enabled constraint is enforced or unenforced.
LAST_CHANGEDateTimeWhen the constraint was last enabled or disabled
INDEX_OWNERStringName of the user owning the index
INDEX_NAMEStringName of the index
ColumnNameDataTypeDescription
OWNERStringOwner of the constraint definition.
CONSTRAINT_NAMEStringName of the constraint definition.
TABLE_NAMEStringName associated with the table (or view) with constraint definition.
SEARCH_CONDITIONStringText of search condition for a check constraint.
R_OWNERStringOwner of table referred to in a referential constraint.
R_CONSTRAINT_NAMEStringName of the unique constraint definition for referenced table.
DELETE_RULEStringDelete rule for a referential constraint (CASCADE or NO ACTION).
STATUSStringEnforcement status of constraint (ENABLED or DISABLED).
DEFERRABLEStringWhether the constraint is deferrable.
VALIDATEDStringWhether all data obeys the constraint (VALIDATED or NOT VALIDATED).
GENERATEDStringWhether the name of the constraint is user or system generated.
BADStringA YES value indicates that this constraint specifies a century in an ambiguous manner. To avoid errors resulting from this ambiguity, rewrite the constraint using the TO_DATE function with a four-digit year.
RELYStringWhether an enabled constraint is enforced or unenforced.
LAST_CHANGEDateTimeWhen the constraint was last enabled or disabled.
INDEX_OWNERStringName of the user owning the index.
INDEX_NAMEStringName of the index.
ColumnNameDataTypeDescription
PRIMARY_KEY_CONSTRAINT_NAMEStringName of the constraint definition.
PRIMARY_KEY_OWNERStringOwner of the constraint definition.
PRIMARY_KEY_TABLE_NAMEStringName associated with the table (or view) with constraint definition
FOREIGN_KEY_OWNERStringOwner of the constraint definition.
FOREIGN_KEY_CONSTRIANT_NAMEStringName of the constraint definition.
FOREIGN_KEY_TABLE_NAMEStringName associated with the table (or view) with constraint definition.
SEARCH_CONDITIONStringText of search condition for a check constraint
R_OWNERStringOwner of table referred to in a referential constraint.
R_CONSTRAINT_NAMEStringName of the unique constraint definition for referenced table.
DELETE_RULEStringDelete rule for a referential constraint (CASCADE or NO ACTION).
STATUSStringEnforcement status of constraint (ENABLED or DISABLED).
VALIDATEDStringWhether all data obeys the constraint (VALIDATED or NOT VALIDATED).
GENERATEDStringWhether the name of the constraint is user or system generated.
RELYStringWhether an enabled constraint is enforced or unenforced.
LAST_CHANGEDateTimeWhen the constraint was last enabled or disabled.
INDEX_OWNERStringName of the user owning the index.
INDEX_NAMEStringName of the index.
ColumnNameDataTypeDescription
OWNERStringOwner of the constraint definition.
CONSTRAINT_NAMEStringName of the constraint definition.
TABLE_NAMEStringName of the table with constraint definition.
COLUMN_NAMEStringName of the column or attribute of the object type column specified in the constraint definition.
POSITIONDecimalOriginal position of column or attribute in the definition of the object.
ColumnNameDataTypeDescription
OWNERStringOwner of the object.
OBJECT_NAMEStringName of the procedure or function.
PACKAGE_NAMEStringName of the procedure or function.
OBJECT_IDDecimalObject number of the object.
OVERLOADStringOverload unique identifier.
ARGUMENT_NAMEStringName of the argument.
POSITIONDecimalPosition in the argument list, or null for a function return value.
SEQUENCEDecimalArgument sequence, including all nesting levels.
DATA_LEVELDecimalNesting depth of the argument for composite types.
DATA_TYPEStringData type of the argument.
DEFAULT_VALUEStringDefault value for the argument.
DEFAULT_LENGTHDecimalLength of the default value for the argument.
IN_OUTStringArgument Direction (IN, OUT, or IN/OUT).
DATA_LENGTHDecimalLength of the column (in bytes).
DATA_PRECISIONDecimalLength in decimal digits (NUMBER) or binary digits (FLOAT).
DATA_SCALEDecimalDigits to the right of the decimal point in a number.
RADIXDecimalArgument radix for a number.
CHARACTER_SET_NAMEStringCharacter set name for the argument.
TYPE_OWNERStringOwner of the type of the argument.
TYPE_NAMEStringName of the type of the argument. If the type is a package local type (that is, it is declared in a package specification), then this column displays the name of the package.
TYPE_SUBNAMEStringRelevant only for package local types. Displays the name of the type declared in the package identified in the TYPE_NAME column.
TYPE_LINKStringRelevant only for package local types when the package identified in the TYPE_NAME column is a remote package. This column displays the database link used to refer to the remote package.
PLS_TYPEStringFor numeric arguments, the name of the PL/SQL type of the argument. Null otherwise.
CHAR_LENGTHDecimalCharacter limit for string data types.
CHAR_USEDStringIndicates whether the byte limit (B) or char limit (C) is official for the string.

ADO.NET Managed Providers and DataSet Developer Center

Show: