Oracle® Database Lite Oracle Lite Client Guide Release 10.3 Part Number E12548-02 |
|
|
View PDF |
The following are the SQLRT and other system catalogs that are included in the client Oracle Lite database:
Table B-2 ALL_CONSTRAINTS Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Owner |
|
|
|
Constraint name |
|
|
|
Constraint type |
|
|
|
Name of the table |
|
|
|
Search condition |
|
|
|
Owner of Referenced Primary Key Constraint |
|
|
|
Reference Name of Primary Constraint |
|
|
|
Delete rule |
|
|
|
Status |
|
|
|
Validated |
Table B-4 ALL_DEPENDENCIES Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Owner |
|
|
|
Name |
|
|
|
Type |
|
|
|
Referenced owner |
|
|
|
Referenced name |
|
|
|
Referenced type |
Table B-5 ALL_INDEXES Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Owner |
|
|
|
Index name |
|
|
|
Table owner |
|
|
|
Table name |
|
|
|
Table type |
|
|
|
Index Uniqueness |
Table B-6 ALL_IND_COLUMNS Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Index owner |
|
|
|
Index name |
|
|
|
Table owner |
|
|
|
Table name |
|
|
|
Column name |
|
|
|
Column position |
Table B-8 ALL_PRIVILEGES Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Schema |
|
|
|
Table |
|
|
|
Column |
|
|
|
Grantor |
|
|
|
Grantee |
|
|
|
Object type |
|
|
|
Grant type |
|
|
|
Grant table |
|
|
|
Not used |
Table B-9 ALL_SEQUENCES Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Sequence owner |
|
|
|
Sequence name |
|
|
|
Minimum value |
|
|
|
Maximum value |
|
|
|
Increment value for sequence |
Table B-11 ALL_TABLES Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Owner |
|
|
|
Table name |
|
|
|
Tablespace name |
|
|
|
Cluster name |
|
|
|
Minimum percentage of free space in a block |
|
|
|
Minimum percentage of used space in a block. Note: If the space in data block is less than PCT_FREE, no new rows will be added in that block until amount of space in table is less than PCT_USED |
|
|
|
Initial number of transactions |
|
|
|
Maximum number of transactions |
|
|
|
Set of Contiguous blocks in a database segment that is automatically allotted when a segment is created |
|
|
|
Block allocated after initial extent |
|
|
|
Minimum number of extents allowed in the segment |
|
|
|
Maximum extent that can be allocated |
|
|
|
Default percentage increase in extent size |
|
|
|
Has table being backed up since last modification |
|
|
|
Number of rows |
|
|
|
Number of used blocks in the table |
|
|
|
Number of empty blocks in the table |
|
|
|
Average available free space in the table |
|
|
|
Number of rows in the table that are chained from one data block to another or that have migrated to a new block, requiring a link to preserve the old rowid |
|
|
|
Average row length, including row overhead |
Table B-12 ALL_TAB_COLUMNS Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Owner |
|
|
|
Table name |
|
|
|
Column name |
|
|
|
Data type |
|
|
|
Data length |
|
|
|
Data precision |
|
|
|
Data scale |
|
|
|
Nullable |
|
|
|
Column ID |
|
|
|
Default length |
|
|
|
Default value for column |
|
|
|
Number of distinct values this column holds |
|
|
|
Low value |
|
|
|
High value |
|
|
|
If item is hidden |
Table B-16 POL__ALLOBJ Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Catalog name |
|
|
|
Schema name |
|
|
|
Object name |
|
|
|
Object ID |
|
|
|
Object type |
|
|
|
Date when created |
|
|
|
Timestamp for the last modification of the object resulting from a DDL command |
Table B-19 POL_CONS Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Catalog |
|
|
|
Schema |
|
|
|
Constraint |
|
|
|
Type |
|
|
|
Reference to POL__TBLCONS that points to constrained table |
|
|
|
Reserved |
|
|
|
Reserved |
|
|
|
For update rules |
|
|
|
Used by foreign key constraint to point to parent table primary key constraint object |
|
|
|
Not used |
Table B-21 POL__INDICES Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Catalog name |
|
|
|
Schema name |
|
|
|
Index name |
|
|
|
Table schema |
|
|
|
Table name |
|
|
|
Options for Index |
|
|
|
Index object |
|
|
|
Not used |
Table B-22 POL__INDICESDT Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Column name |
|
|
|
Ascending or descending direction |
|
|
|
Relative position in index |
|
|
|
Master index table |
|
|
|
Not used |
Table B-23 POL__PROCEDURES Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Catalog name |
|
|
|
Schema name |
|
|
|
Procedure name |
|
|
|
Table class |
|
|
|
Procedure type |
|
|
|
Procedure reference |
Table B-24 POL__PROCEDURE_COLUMNS Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Master Index table |
|
|
|
Column type |
|
|
|
Data type |
|
|
|
Type name |
|
|
|
Significant digits for Column |
|
|
|
Length |
|
|
|
Significant digits right of decimal |
|
|
|
Base of the system |
|
|
|
Position |
Table B-26 POL__SEQ Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Schema name |
|
|
|
Sequence name |
|
|
|
Sequence reference |
|
|
|
Increment by value |
|
|
|
Number to start sequence with |
|
|
|
Minimum value for sequence |
|
|
|
Maximum value for sequence |
|
|
|
if accessed |
Table B-28 POL__TBLCONS Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Fully qualified database file name |
|
|
|
Schema |
|
|
|
Table |
|
|
|
Reference to POL__CONS object |
|
|
|
Reserved |
|
|
|
Type |
|
|
|
Used by Check constraint to store user constraint string |
|
|
|
Internal representation of constraint clause |
|
|
|
Not used |
|
|
|
Reference to Class Object for the table |
|
|
|
Reference to Group Object for the table |
Table B-29 POL_TBLUSAGE Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Catalog |
|
|
|
Schema |
|
|
|
Table |
|
|
|
Reference to POL__TBLCONS Object |
|
|
|
Not used |
|
|
|
Not used |
|
|
|
Not used |