Release 5.0.1
Part No. A95912-01
 Contents |
 Index |
|
Oracle9i Lite Developers Guide for Windows 32
Release 5.0.1 Part No. A95912-01 |
|
This document is a reference to the system catalog views for the Oracle Lite database. This appendix covers the following sets of catalog views:
The following views are available in the Oracle Lite database system catalog:
|
Note: In the following tables, columns marked with an asterisk are not used by Oracle Lite, but are compatible with Oracle8i and generally return NULL or a default value. |
This view lists user comments for table columns.
Table B-1 ALL_COL_COMMENTS Parameters
| Column | Datatype | NULL | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NOT NULL | Owner of the table. |
| TABLE_NAME | VARCHAR2(128) | NOT NULL | Name of the object. |
| COLUMN_NAME | VARCHAR2(128) | NOT NULL | Name of the column. |
| COMMENTS | VARCHAR2(4096) | Text of the column comment. |
This view provides the following information about constraint definitions on accessible tables.
Table B-2 ALL_CONSTRAINTS Parameters
| Column | Datatype | NULL | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NOT NULL | Owner of the constraint definition. |
| CONSTRAINT_NAME | VARCHAR2(128) | NOT NULL | Name associated with the constraint definition. |
| CONSTRAINT_TYPE | VARCHAR2(128) | NOT NULL | Type of constraint definition:
C (check constraint on a table) P (primary key) U (unique key) R (referential integrity) V (with check option, on a view) |
| TABLE_NAME | VARCHAR2(128) | NOT NULL | Name of table with constraint definition. |
| SEARCH_CONDITION | VARCHAR2(1000) | Text of search condition for table check. | |
| R_OWNER | VARCHAR2(128) | Owner of table used in referential constraint. | |
| R_CONSTRAINT_NAME | VARCHAR2(128) | Name of unique constraint definition for referenced table. | |
| DELETE_RULE | VARCHAR2(128) | Delete rule for a referential constraint: "NO ACTION". | |
| STATUS | VARCHAR2(20) | NOT NULL | Status of constraint: "ENABLED" or "DISABLED". |
| VALIDATED | VARCHAR2(13) | Status of constraint: "VALIDATED" or "NOT VALIDATED". |
This view provides the following information about accessible columns in constraint definitions.
Table B-3 ALL_CONS_COLUMNS Parameters
| Column | Datatype | NULL | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | User name of owner of the constraint definition. | |
| CONSTRAINT_NAME | VARCHAR2(128) | Name associated with the constraint definition. | |
| TABLE_NAME | VARCHAR2(128) | Name of table with constraint definition. | |
| COLUMN_NAME | VARCHAR2(128) | Name associated with column specified in the constraint definition. | |
| POSITION | NUMBER(10) | Original position of column in definition. |
This view contains descriptions of all indexes defined on tables.
Table B-4 ALL_INDEXES Parameters
| Column | Datatype | NULL | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NOT NULL | Owner of the INDEX definition. |
| INDEX_NAME | VARCHAR2(128) | NOT NULL | Name associated with the INDEX definition. |
| TABLE_OWNER | VARCHAR2(128) | NOT NULL | Owner of the table on which the INDEX is defined. |
| TABLE_NAME | VARCHAR2(128) | NOT NULL | Name of table with INDEX definition. |
| TABLE_TYPE | VARCHAR2(10) | Type of the object. | |
| UNIQUENESS | VARCHAR2(128) | NOT NULL | This is a string containing "UNIQUE" or "NONUNIQUE". |
This view lists index key columns for all indexes in the database.
Table B-5 ALL_IND_COLUMNS Parameters
| Column | Datatype | NULL | Description |
|---|---|---|---|
| INDEX_OWNER | VARCHAR2(128) | NOT NULL | Owner of the INDEX definition. |
| INDEX_NAME | VARCHAR2(128) | NOT NULL | Name associated with the INDEX definition. |
| TABLE_OWNER | VARCHAR2(128) | NOT NULL | Owner of the table on which the INDEX is defined. |
| TABLE_NAME | VARCHAR2(128) | NOT NULL | Name of table with INDEX definition. |
| COLUMN_NAME | VARCHAR2(128) | NOT NULL | Name associated with column specified in the INDEX definition. |
| COLUMN_POSITION | NUMBER(10) | NOT NULL | Position of the column in the index definition. |
This view contains descriptions of the objects (tables, views, synonyms, indexes, and sequences).
Table B-6 ALL_OBJECTS Parameters
| Column | Datatype | NULL | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NOT NULL | Owner of the OBJECTS definition. |
| OBJECT_NAME | VARCHAR2(128) | NOT NULL | Name associated with the OBJECTS definition. |
| OBJECT_TYPE | VARCHAR2(128) | Type of the object: TABLE, VIEW, INDEX, SEQUENCE, SYNONYM. | |
| CREATED | DATE | Timestamp for the creation of the OBJECTS. | |
| STATUS | VARCHAR2(128) | Status of the OBJECTS: VALID, INVALID, or N/A (always valid). |
This view lists descriptions of all sequences in the database.
Table B-7 ALL_SEQUENCES Parameters
| Column | Datatype | NULL | Description |
|---|---|---|---|
| SEQUENCE_OWNER | VARCHAR2(128) | NOT NULL | Owner of the SEQUENCES definition. |
| SEQUENCE_NAME | VARCHAR2(128) | NOT NULL | Name associated with the SEQUENCES definition. |
| MIN_VALUE | NUMBER(10) | NOT NULL | Minimum value of the sequence. |
| MAX_VALUE | NUMBER(10) | NOT NULL | Maximum value of the sequence. |
| INCREMENT_BY | NUMBER(10) | NOT NULL | Increment amount for the sequence. |
This view lists all synonyms in the database.
Table B-8 ALL_SYNONYMS Parameters
| Column | Datatype | NULL | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | Owner of the SYNONYMS definition. | |
| SYNONYM_NAME | VARCHAR2(128) | Name associated with the SYNONYMS definition. | |
| TABLE_OWNER | VARCHAR2(128) | Owner of the table on which the SYNONYMS is defined. | |
| TABLE_NAME | VARCHAR2(128) | Name of table with SYNONYMS definition. | |
| DB_LINK | VARCHAR2(128) | Reserved. |
This view provides the following information about tables accessible to the user.
Table B-9 ALL_TABLES Parameter
| Column | Datatype | NULL | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NOT NULL | User name of the owner of the table. |
| TABLE_NAME | VARCHAR2(128) | NOT NULL | Name of the table. |
| TABLESPACE_NAME | VARCHAR2(128) | Name of the catalog or database file containing the table. | |
| CLUSTER_NAME* | VARCHAR2(128) | Name of the cluster, if any, to which the table belongs. | |
| PCT_FREE* | NUMBER(10) | Minimum percentage of free space in a block. | |
| PCT_USED* | NUMBER(10) | Minimum percentage of used space in a block. | |
| INI_TRANS* | NUMBER(10) | Initial number of transactions. | |
| MAX_TRANS* | NUMBER(10) | Maximum number of transactions. | |
| INITIAL_EXTENT* | NUMBER(10) | Size of the initial extent in bytes. | |
| NEXT_EXTENT* | NUMBER(10) | Size of secondary extents in bytes. | |
| MIN_EXTENTS* | NUMBER(10) | Minimum number of extents allowed in the segment. | |
| MAX_EXTENTS* | NUMBER(10) | Maximum number of extents allowed in the segment. | |
| PCT_INCREASE* | NUMBER(10) | Percentage increase in extent size. | |
| BACKED_UP* | VARCHAR2(1) | If the table was backed up since last change. | |
| NUM_ROWS* | NUMBER(10) | Number of rows in the table. | |
| BLOCKS* | NUMBER(10) | Number of data blocks allocated to the table. | |
| EMPTY_BLOCKS* | NUMBER(10) | Number of data blocks allocated to the table that contain no data. | |
| AVG_SPACE* | NUMBER(10) | Average amount of free space (in bytes) in a data block allocated to the table. | |
| CHAIN_CNT* | NUMBER(10) | 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. | |
| AVG_ROW_LEN* | NUMBER(10) | Average length of a row in the table in bytes. |
This view provides the following information about the columns of tables, views, and clusters accessible to the user.
Table B-10 ALL_TAB_COLUMNS Parameters
| Column | Datatype | NULL | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NOT NULL | User name of owner of the table, view, or cluster. |
| TABLE_NAME | VARCHAR2(128) | NOT NULL | Table, view, or cluster name. |
| COLUMN_NAME | VARCHAR2(128) | NOT NULL | Column name. |
| DATA_TYPE | VARCHAR2(30) | Datatype of the column. | |
| DATA_LENGTH | NUMBER(10) | Length of the column in bytes. | |
| DATA_PRECISION | NUMBER(10) | Decimal precision for NUMERIC and DECIMAL datatype;binary precision for FLOAT, REAL, and DOUBLE datatype; NULL for all other datatypes. | |
| DATA_SCALE | NUMBER(10) | Digits to the right of decimal point in a NUMERIC or DECIMAL. | |
| NULLABLE | VARCHAR2(1) | Indicates if the 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. | |
| COLUMN_ID | NUMBER(10) | NOT NULL | Sequence number of the column as created. |
| DEFAULT_LENGTH | NUMBER(10) | Length of default value for the column. | |
| DATA_DEFAULT | VARCHAR2(4096) | Default value for the column. | |
| NUM_DISTINCT* | NUMBER(10) | Number of distinct values in each column of the table. | |
| LOW_VALUE* | NUMBER(10) | See description in HIGH_VALUE. | |
| HIGH_VALUE* | NUMBER(10) | For tables with more than three rows, the second-lowest and second-highest values in the column. For tables with three rows or fewer, the lowest and highest values. These statistics are expressed in hexadecimal notation for the internal representation of the first 32 bytes of the values. |
This view lists comments on tables and views entered by users.
Table B-11 ALL_TAB_COMMENTS Parameters
| Column | Datatype | NULL | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NOT NULL | Owner of the TAB_COMMENTS definition. |
| TABLE_NAME | VARCHAR2(128) | NOT NULL | Name of table with TAB_COMMENTS definition. |
| TABLE_TYPE | VARCHAR2(128) | NOT NULL | Type of the object. |
| COMMENTS | VARCHAR2(4096) | NOT NULL | Comment text. |
This view provides the following information about all schemas created in the connected database.
Table B-12 ALL_USERS Parameters
| Column | Datatype | NULL | Description |
|---|---|---|---|
| USERNAME | VARCHAR2(30) | NOT NULL | Name of the user. |
| USER_ID* | NUMBER | NOT NULL | ID number of the user. |
| CREATED | DATE | NOT NULL | User creation date. |
This view provides the following information about views accessible to the user.
Table B-13 ALL_VIEWS Parameters
| Column | Datatype | NULL | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NOT NULL | User name of the owner of the view. |
| VIEW_NAME | VARCHAR2(128) | NOT NULL | Name of the view. |
| TEXT_LENGTH | NUMBER(10) | NOT NULL | Length of the view text. |
| TEXT | VARCHAR2(1000) | NOT NULL | View text. |
This view provides the following information about tables and views accessible to the user.
Table B-14 CAT Parameters
| Column | Datatype | NULL | Description |
|---|---|---|---|
| TABLE_NAME | VARCHAR2(128) | NOT NULL | Name of the object. |
| TABLE_TYPE | VARCHAR2(128) | NOT NULL | Type of the object: TABLE or VIEW. |
This view provides the following information about grants on columns for which the user is the grantor, grantee, or owner, or for which PUBLIC is the grantee.
Table B-15 COLUMN_PRIVILEGES Parameters
| Column | Datatype | NULL | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NOT NULL | User name of the owner of the object. |
| TABLE_NAME | VARCHAR2(128) | NOT NULL | Name of the object. |
| COLUMN_NAME | VARCHAR2(128) | Name of the column. | |
| GRANTOR | VARCHAR2(128) | Name of the user who performed the grant. | |
| GRANTEE | VARCHAR2(128) | Name of the user to whom access was granted. | |
| GRANT_TYPE | VARCHAR2(128) | NOT NULL | Privilege on the object. The value can be SELECT, INSERT, or DELETE. |
| GRANTABLE | VARCHAR2(128) | YES, if the privilege was granted with GRANT OPTION, otherwise NO. |
This view lists the value for the NLS_SORT parameter, which controls collation sequence.
Table B-16 DATABASE_PARAMETERS Parameters
| Column | Datatype | Null | Description |
|---|---|---|---|
| PARAMETER | VARCHAR2(30) | NOT NULL | NLS_SORT |
| VALUE | VARCHAR2(128) | Collation sequence string constant. The value can be BINARY, FRENCH, GERMAN, CZECH, or XCZECH. |
This view is a dummy table which can be used in a query when you want to return a single row. For example, you could use DUAL to select CURRENT_TIMESTAMP.
Table B-17 DUAL Parameters
| Column | Datatype | NULL | Description |
|---|---|---|---|
| DUMMY | VARCHAR2(1) | NOT NULL | Always "X". |
This view does not exist by default and is only created during replication. It provides the following information about snapshots accessible to the user.
Table B-18 SNAPSHOTS Parameters
| Column | Datatype | NULL | Description |
|---|---|---|---|
| OWNER | VARCHAR2(30) | Owner of the snapshot. | |
| NAME | VARCHAR2(30) | Name of the view used by users and applications for viewing the snapshot. | |
| TABLE_NAME | VARCHAR2(30) | Table in which the snapshot is stored. | |
| MASTER_VIEW | VARCHAR2(30) | Name of the snapshot master view. | |
| MASTER_OWNER | VARCHAR2(30) | Owner of the master table. | |
| MASTER | VARCHAR2(30) | Name of the master table of which this snapshot is a copy. | |
| MASTER_LINK | VARCHAR2(128) | Database link name to the master site. | |
| MASTER_ROLLBACK | VARCHAR2(30) | Rollback segment to use at the master site. | |
| CAN_USE_LOG | VARCHAR2(3) | Specifies whether the snapshot can use a snapshot log. YES if this snapshot can use a snapshot log, and NO if this snapshot is too complex to use a log. | |
| UPDATABLE | VARCHAR2(3) | Specifies whether the snapshot is updatable. YES if it is updatable, and NO if it is not. If NO, the snapshot is read-only. | |
| SUBQUERY | VARCHAR2(3) | Specifies whether the snapshot query has a subquery. YES if it does have a subquery, and NO if it does not. | |
| KEYTYPE | VARCHAR2(4) | For Oracle7, specifies whether the snapshot is a ROWID or a primary key snapshot. Values are: R for ROWID, P for primary key. | |
| SNAPSHOT_ID | DATE | For Oracle7, specifies a unique ID for the snapshot. | |
| SNAPSHOT_ID8 | NUMBER | For Oracle8, specifies a unique ID for the snapshot. | |
| SNAPTYPE | NUMBER | For Oracle8, specifies whether the snapshot is a ROWID or primary key snapshot. Values are: R for ROWID, P for primary key. | |
| REFMETHOD | NUMBER | Specifies the type of refresh. Values are: COMPLETE, FAST, OPTIMUM (FORCE). This column is for Oracle internal use only. | |
| LAST_REFRESH | DATE | Date and time at the master site of the last refresh. | |
| TYPE | VARCHAR2(8) | Specifies the type of snapshot. Values are C for complex and S for simple. | |
| NEXT | VARCHAR2(200) | Date function used to compute next refresh date. | |
| START_WITH | DATE | Date function used to compute first refresh date. | |
| REFRESH_GROUP | NUMBER | Specifies the ID of the refresh group. | |
| UPDATE_TRIG | VARCHAR2(30) | Name of the trigger that fills the UPDATE_LOG. | |
| UPDATE_LOG | VARCHAR2(30) | The table that logs changes made to an updatable snapshot. | |
| STATUS | VARCHAR2(8) | Specifies the run-time refresh status. | |
| PKCOLS | VARCHAR2(1056) | Stores the primary key columns. | |
| TABLE_COUNT | NUMBER | Specifies the table count for subquery snapshots. | |
| SCHEMA_CHANGED | CHAR(1) | Indicates whether the master schema changed. YES, if it changed, and NO, if it did not change. | |
| HIDDEN_COLUMNS | VARCHAR2(1056) | Stores the hidden columns. | |
| QUERY | LONG | SQL query that defines the snapshot. |
This view provides the following information about grants on objects for which the user or PUBLIC is the grantee.
Table B-19 TABLE_PRIVILEGES Parameters
| Column | Datatype | NULL | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NOT NULL | User name of the owner of the object. |
| TABLE_NAME | VARCHAR2(128) | NOT NULL | Name of the object. |
| GRANTOR | VARCHAR2(128) | Name of the user who performed the grant. | |
| GRANTEE | VARCHAR2(128) | Name of the user to whom access is granted. | |
| GRANT_TYPE | VARCHAR2(128) | NOT NULL | Privilege on the object. The value can be one of the following: SELECT, INSERT, or DELETE. |
| GRANTABLE | VARCHAR2(128) | YES, if the privilege was granted with GRANT OPTION, and NO, if it was not. |
This view provides the following information about objects accessible to the user.
Table B-20 USER_OBJECTS Parameters
| Column | Datatype | NULL | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NOT NULL | User name of the owner of the object. |
| OBJECT_NAME | VARCHAR2(128) | NOT NULL | Name of the object. |
| OBJECT_ID | NUMBER(10) | NOT NULL | Object identifier of the object. |
| OBJECT_TYPE | VARCHAR2(128) | Type of the object: TABLE, VIEW, INDEX, SEQUENCE, SYNONYM. | |
| CREATED | DATE | Timestamp for the creation of the object. | |
| LAST_DDL_TIME | DATE | Timestamp for the last modification of the object resulting from a DDL command (including grants and revokes). | |
| CREATED_TIME | VARCHAR2(128) | Timestamp for the creation of the object (character data). | |
| STATUS* | VARCHAR2(128) | Status of the object: VALID, INVALID, or N/A (always valid). |
|
 Copyright © 2002 Oracle Corporation All rights reserved |
|