B Catalog Views for the Oracle Lite Client

T he following are the SQLRT and other system catalogs that are included in the client Oracle Lite database:

Section B.1, "ALL_COL_COMMENTS"
Section B.2, "ALL_CONSTRAINTS"
Section B.3, "ALL_CONS_COLUMNS"
Section B.4, "ALL_DEPENDENCIES"
Section B.5, "ALL_INDEXES"
Section B.6, "ALL_IND_COLUMNS"
Section B.7, "ALL_OBJECTS"
Section B.8, "ALL_PRIVILEGES"
Section B.9, "ALL_SEQUENCES"
Section B.10, "ALL_SYNONYMS"
Section B.11, "ALL_TABLES"
Section B.12, "ALL_TAB_COLUMNS"
Section B.13, "ALL_TAB_COMMENTS"
Section B.14, "ALL_USERS"
Section B.15, "ALL_VIEWS"
Section B.16, "POL__ALLOBJ"
Section B.17, "POL__COLUSAGE"
Section B.18, "POL__COMMENT"
Section B.19, "POL__CONS"
Section B.20, "POL__DATABASE_PARAMETERS"
Section B.21, "POL__INDICES"
Section B.22, "POL__INDICESDT"
Section B.23, "POL__PROCEDURES"
Section B.24, "POL__PROCEDURE_COLUMNS"
Section B.25, "POL__SCHEMATA"
Section B.26, "POL__SEQ"
Section B.27, "POL__SYNONYM"
Section B.28, "POL__TBLCONS"
Section B.29, "POL__TBLUSAGE"
Section B.30, "POL__TRIGGERS"
Section B.31, "POL__VIEWS"
Section B.32, "POL__USERS"

B.1 ALL_COL_COMMENTS

Table B-1 ALL_COL_COMMENTS Parameters

Column	Datatype	Null	Description
`OWNER`	`VARCHAR(128)`	`NOT NULL`	Owner
`TABLE_NAME`	`VARCHAR(128)`	`NOT NULL`	Name of the table
`COLUMN_NAME`	`VARCHAR(128)`	`NOT NULL`	Name of the column
`COMMENTS`	`VARCHAR(4096)`	`NULL`	Description

B.2 ALL_CONSTRAINTS

Table B-2 ALL_CONSTRAINTS Parameters

Column	Datatype	Null	Description
`OWNER`	`VARCHAR(128)`	`NOT NULL`	Owner
`CONSTRAINT_NAME`	`VARCHAR(128)`	`NOT NULL`	Constraint name
`CONSTRAINT_TYPE`	`VARCHAR(128)`	`NOT NULL`	Constraint type
`TABLE_NAME`	`VARCHAR(128)`	`NOT NULL`	Name of the table
`SEARCH_CONDITION`	`VARCHAR(1000)`	`NULL`	Search condition
`R_OWNER`	`VARCHAR(128)`	`NULL`	Owner of Referenced Primary Key Constraint
`R_CONSTRAINT_NAME`	`VARCHAR(128)`	`NULL`	Reference Name of Primary Constraint
`DELETE_RULE`	`VARCHAR(128)`	`NULL`	Delete rule
`STATUS`	`VARCHAR(20)`	`NOT NULL`	Status
`VALIDATED`	`VARCHAR(13)`	`NOT NULL`	Validated

B.3 ALL_CONS_COLUMNS

Table B-3 ALL_CONS_COLUMNS Parameters

Column	Datatype	Null	Description
`OWNER`	`VARCHAR(128)`	`NULL`	Owner
`CONSTRAINT_NAME`	`VARCHAR(128)`	`NULL`	Constraint name
`TABLE_NAME`	`VARCHAR(128)`	`NULL`	Table name
`COLUMN_NAME`	`VARCHAR(128)`	`NULL`	Column name
`POSITION`	`VARCHAR(10)`	`NULL`	Position

B.4 ALL_DEPENDENCIES

Table B-4 ALL_DEPENDENCIES Parameters

Column	Datatype	Null	Description
`OWNER`	`VARCHAR(30)`	`NOT NULL`	Owner
`NAME`	`VARCHAR(30)`	`NOT NULL`	Name
`TYPE`	`VARCHAR(16)`	`NULL`	Type
`REFERENCED_OWNER`	`VARCHAR(30)`	`NULL`	Referenced owner
`REFERENCED_NAME`	`VARCHAR(30)`	`NOT NULL`	Referenced name
`REFERENCED_TYPE`	`VARCHAR(16)`	`NULL`	Referenced type

B.5 ALL_INDEXES

Table B-5 ALL_INDEXES Parameters

Column	Datatype	Null	Description
`OWNER`	`VARCHAR(128)`	`NOT NULL`	Owner
`INDEX_NAME`	`VARCHAR(128)`	`NOT NULL`	Index name
`TABLE_OWNER`	`VARCHAR(128)`	`NOT NULL`	Table owner
`TABLE_NAME`	`VARCHAR(128)`	`NOT NULL`	Table name
`TABLE_TYPE`	`VARCHAR(10)`	`NULL`	Table type
`UNIQUENESS`	`VARCHAR(128)`	`NOT NULL`	Index Uniqueness

B.6 ALL_IND_COLUMNS

Table B-6 ALL_IND_COLUMNS Parameters

Column	Datatype	Null	Description
`INDEX_OWNER`	`VARCHAR(128)`	`NOT NULL`	Index owner
`INDEX_NAME`	`VARCHAR(128)`	`NOT NULL`	Index name
`TABLE_OWNER`	`VARCHAR(128)`	`NOT NULL`	Table owner
`TABLE_NAME`	`VARCHAR(128)`	`NOT NULL`	Table name
`COLUMN_NAME`	`VARCHAR(128)`	`NOT NULL`	Column name
`COLUMN_POSITION`	`VARCHAR(10)`	`NOT NULL`	Column position

B.7 ALL_OBJECTS

Table B-7 ALL_OBJECTS Parameters

Column	Datatype	Null	Description
`OWNER`	`VARCHAR(128)`	`NOT NULL`	Owner
`OBJECT_NAME`	`VARCHAR(128)`	`NOT NULL`	Object name
`OBJECT_TYPE`	`VARCHAR(128)`	`NULL`	Object type
`CREATED`	`DATE`	`NULL`	When object was created
`STATUS`	`VARCHAR(128)`	`NULL`	Status

B.8 ALL_PRIVILEGES

Table B-8 ALL_PRIVILEGES Parameters

Column	Datatype	Null	Description
`SCHEMA`	`VARCHAR(128)`	`NOT NULL`	Schema
`TABLE`	`VARCHAR(128)`	`NOT NULL`	Table
`COLUMN`	`NUMBER(11)`	`NOT NULL`	Column
`GRANTOR1`	`VARCHAR(128)`	`NOT NULL`	Grantor
`GRANTEE1`	`UNKNOWN(8)`	`NOT NULL`	Grantee
`OBJTYPE`	`TINYINT(3)`	`NOT NULL`	Object type
`GTYPE`	`TINYINT(3)`	`NOT NULL`	Grant type
`GTABLE`	`TINYINT(3)`	`NOT NULL`	Grant table
`TO`	`UNKNOWN(8)`	`NOT NULL`	Not used

B.9 ALL_SEQUENCES

Table B-9 ALL_SEQUENCES Parameters

Column	Datatype	Null	Description
`SEQUENCE_OWNER`	`VARCHAR(128)`	`NOT NULL`	Sequence owner
`SEQUENCE_NAME`	`VARCHAR(128)`	`NOT NULL`	Sequence name
`MIN_VALUE`	`VARCHAR(10)`	`NOT NULL`	Minimum value
`MAX_VALUE`	`VARCHAR(10)`	`NOT NULL`	Maximum value
`INCREMENT_BY`	`VARCHAR(10)`	`NOT NULL`	Increment value for sequence

B.10 ALL_SYNONYMS

Table B-10 ALL_SYNONYMS Parameters

Column	Datatype	Null	Description
`OWNER`	`VARCHAR(128)`	`NULL`	Owner
`SYNONYM_NAME`	`VARCHAR(128)`	`NULL`	Synonym name
`TABLE_OWNER`	`VARCHAR(128)`	`NULL`	Table owner
`TABLE_NAME`	`VARCHAR(128)`	`NULL`	Table name
`DB_LINK`	`VARCHAR(128)`	`NULL`	Database link

B.11 ALL_TABLES

Table B-11 ALL_TABLES Parameters

Column	Datatype	Null	Description
`OWNER`	`VARCHAR(128)`	`NOT NULL`	Owner
`TABLE_NAME`	`VARCHAR(128)`	`NOT NULL`	Table name
`TABLESPACE_NAME`	`VARCHAR(128)`	`NULL`	Tablespace name
`CLUSTER_NAME`	`VARCHAR(128)`	`NULL`	Cluster name
`PCT_FREE`	`NUMBER(10)`	`NULL`	Minimum percentage of free space in a block
`PCT_USED`	`NUMBER(10)`	`NULL`	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
`INI_TRANS`	`NUMBER(10)`	`NULL`	Initial number of transactions
`MAX_TRANS`	`NUMBER(10)`	`NULL`	Maximum number of transactions
`INITIAL_EXTENT`	`NUMBER(10)`	`NULL`	Set of Contiguous blocks in a database segment that is automatically allotted when a segment is created
`NEXT_EXTENT`	`NUMBER(10)`	`NULL`	Block allocated after initial extent
`MIN_EXTENTS`	`NUMBER(10)`	`NULL`	Minimum number of extents allowed in the segment
`MAX_EXTENTS`	`NUMBER(10)`	`NULL`	Maximum extent that can be allocated
`PCT_INCREASE`	`NUMBER(10)`	`NULL`	Default percentage increase in extent size
`BACKED_UP`	`VARCHAR(1)`	`NULL`	Has table being backed up since last modification
`NUM_ROWS`	`NUMBER(10)`	`NULL`	Number of rows
`BLOCKS`	`NUMBER(10)`	`NULL`	Number of used blocks in the table
`EMPTY_BLOCKS`	`NUMBER(10)`	`NULL`	Number of empty blocks in the table
`AVG_SPACE`	`NUMBER(10)`	`NULL`	Average available free space in the table
`CHAIN_CNT`	`NUMBER(10)`	`NULL`	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)`	`NULL`	Average row length, including row overhead

B.12 ALL_TAB_COLUMNS

Table B-12 ALL_TAB_COLUMNS Parameters

Column	Datatype	Null	Description
`OWNER`	`VARCHAR(128)`	`NOT NULL`	Owner
`TABLE_NAME`	`VARCHAR(128)`	`NOT NULL`	Table name
`COLUMN_NAME`	`VARCHAR(128)`	`NOT NULL`	Column name
`DATA_TYPE`	`VARCHAR(30)`	`NULL`	Data type
`DATA_LENGTH`	`NUMBER(10)`	`NULL`	Data length
`DATA_PRECISION`	`NUMBER(10)`	`NULL`	Data precision
`DATA_SCALE`	`NUMBER(10)`	`NULL`	Data scale
`NULLABLE`	`VARCHAR(1)`	`NULL`	Nullable
`COLUMN_ID`	`NUMBER(10)`	`NOT NULL`	Column ID
`DEFAULT_LENGTH`	`NUMBER(10)`	`NULL`	Default length
`DATA_DEFAULT`	`VARCHAR(4096)`	`NULL`	Default value for column
`NUM_DISTINCT`	`NUMBER(10)`	`NULL`	Number of distinct values this column holds
`LOW_VALUE`	`NUMBER(10)`	`NULL`	Low value
`HIGH_VALUE`	`NUMBER(10)`	`NULL`	High value
`IS_HIDDEN`	`VARCHAR(1)`	`NULL`	If item is hidden

B.13 ALL_TAB_COMMENTS

Table B-13 ALL_TAB_COMMENTS Parameters

Column	Datatype	Null	Description
`OWNER`	`VARCHAR(128)`	`NOT NULL`	Owner
`TABLE_NAME`	`VARCHAR(128)`	`NOT NULL`	Table name
`TABLE_TYPE`	`VARCHAR(128)`	`NOT NULL`	Table type
`COMMENTS`	`VARCHAR(4096)`	`NOT NULL`	Description

B.14 ALL_USERS

Table B-14 ALL_USERS Parameters

Column	Datatype	Null	Description
`USERNAME`	`VARCHAR(30)`	`NOT NULL`	Username
`USER_ID`	`NUMBER(11)`	`NOT NULL`	User ID
`CREATED`	`DATE`	`NOT NULL`	When user was created

B.15 ALL_VIEWS

Table B-15 ALL_VIEWS Parameters

Column	Datatype	Null	Description
`OWNER`	`VARCHAR(128)`	`NOT NULL`	Owner
`VIEW_NAME`	`VARCHAR(128)`	`NOT NULL`	View name
`TEXT_LENGTH`	`NUMBER(10)`	`NOT NULL`	Text length
`TEXT`	`VARCHAR(1000)`	`NOT NULL`	Text

B.16 POL__ALLOBJ

Table B-16 POL__ALLOBJ Parameters

Column	Datatype	Null	Description
`CATALOG_NAME`	`VARCHAR(128)`	`NOT NULL`	Catalog name
`SCHEMA_NAME`	`VARCHAR(128)`	`NOT NULL`	Schema name
`OBJECT_NAME`	`VARCHAR(128)`	`NOT NULL`	Object name
`OBJECT_ID`	`NUMBER(10)`	`NOT NULL`	Object ID
`OBJECT_TYPE`	`SMALLINT(5)`	`NOT NULL`	Object type
`CREATED`	`DATE`	`NOT NULL`	Date when created
`LAST_DDL_TIME`	`DATE`	`NOT NULL`	Timestamp for the last modification of the object resulting from a DDL command

B.17 POL__COLUSAGE

Table B-17 POL__COLUSAGE Parameters

Column	Datatype	Null	Description
`COLUMN`	`VARCHAR(128)`	`NOT NULL`	Column
`TBLUSAGEREF`	`UNKNOWN(8)`	`NOT NULL`	Reference to its POL__TBLUSAGE object
`POSITION`	`NUMBER(11)`	`NOT NULL`	Column position in Constraint definition. Used to identify order of column in the key

B.18 POL__COMMENT

Table B-18 POL__COMMENT Parameters

Column	Datatype	Null	Description
`COLREF`	`UNKNOWN(8)`	`NOT NULL`	Column Reference
`COMMENTS`	`VARCHAR(4096)`	`NOT NULL`	Comment

B.19 POL__CONS

Table B-19 POL_CONS Parameters

Column	Datatype	Null	Description
`CATALOG`	`VARCHAR(128)`	`NOT NULL`	Catalog
`SCHEMA`	`VARCHAR(128)`	`NOT NULL`	Schema
`CONSTRAINT`	`VARCHAR(128)`	`NOT NULL`	Constraint
`TYPE`	`NUMBER(11)`	`NOT NULL`	Type
`TBLCONS`	`UNKNOWN(8)`	`NOT NULL`	Reference to POL__TBLCONS that points to constrained table
`ASSERTCONS`	`UNKNOWN(8)`	`NOT NULL`	Reserved
`DOMAINCONS`	`UNKNOWN(8)`	`NOT NULL`	Reserved
`FLAGS`	`NUMBER(11)`	`NOT NULL`	For update rules
`TO`	`UNKNOWN(8)`	`NOT NULL`	Used by foreign key constraint to point to parent table primary key constraint object
`EXTENSIONS`	`TINYINT(3)`	`NOT NULL`	Not used

B.20 POL__DATABASE_PARAMETERS

Table B-20 POL__DATABASE_PARAMETERS Parameters

Column	Datatype	Null	Description
`PARAMETER`	`VARCHAR(30)`	`NOT NULL`	Parameter
`TYPE`	`TINYINT(3)`	`NOT NULL`	Type
`VALUE`	`VARCHAR(128)`	`NULL`	Value

B.21 POL__INDICES

Table B-21 POL__INDICES Parameters

Column	Datatype	Null	Description
`CATALOG_NAME`	`VARCHAR(128)`	`NOT NULL`	Catalog name
`SCHEMA_NAME`	`VARCHAR(128)`	`NOT NULL`	Schema name
`INDEX_NAME`	`VARCHAR(128)`	`NOT NULL`	Index name
`TABLE_SCHEMA`	`VARCHAR(128)`	`NOT NULL`	Table schema
`TABLE_NAME`	`VARCHAR(128)`	`NOT NULL`	Table name
`FLAGS`	`NUMBER(11)`	`NOT NULL`	Options for Index
`INDEXOBJ`	`UNKNOWN(8)`	`NOT NULL`	Index object
`EXTENSIONS`	`TINYINT(3)`	`NOT NULL`	Not used

B.22 POL__INDICESDT

Table B-22 POL__INDICESDT Parameters

Column	Datatype	Null	Description
`COLUMN_NAME`	`VARCHAR(128)`	`NOT NULL`	Column name
`DIRECTION`	`TINYINT(3)`	`NOT NULL`	Ascending or descending direction
`INDEX_POSITION`	`NUMBER(10)`	`NOT NULL`	Relative position in index
`MASTER`	`UNKNOWN(8)`	`NOT NULL`	Master index table
`EXTENSIONS`	`TINYINT(3)`	`NOT NULL`	Not used

B.23 POL__PROCEDURES

Table B-23 POL__PROCEDURES Parameters

Column	Datatype	Null	Description
`CATALOG_NAME`	`VARCHAR(128)`	`NOT NULL`	Catalog name
`SCHEMA_NAME`	`VARCHAR(128)`	`NOT NULL`	Schema name
`PROCEDURE_NAME`	`VARCHAR(128)`	`NOT NULL`	Procedure name
`TABLE_CLASS`	`UNKONWN(8)`	`NOT NULL`	Table class
`PROCEDURE_TYPE`	`SMALLINT(5)`	`NOT NULL`	Procedure type
`PROCEDURE_REF`	`UNKNOWN(8)`	`NOT NULL`	Procedure reference

B.24 POL__PROCEDURE_COLUMNS

Table B-24 POL__PROCEDURE_COLUMNS Parameters

Column	Datatype	Null	Description
`MASTER`	`UNKNOWN(8)`	`NOT NULL`	Master Index table
`COLUMN_TYPE`	`SMALLINT(5)`	`NOT NULL`	Column type
`DATA_TYPE`	`SMALLINT(5)`	`NOT NULL`	Data type
`TYPE_NAME`	`VARCHAR(128)`	`NOT NULL`	Type name
`PRECISION`	`NUMBER(10)`	`NOT NULL`	Significant digits for Column
`LENGTH`	`NUMBER(10)`	`NOT NULL`	Length
`SCALE`	`SMALLINT(5)`	`NOT NULL`	Significant digits right of decimal
`RADIX`	`SMALLINT(5)`	`NOT NULL`	Base of the system
`POSITION`	`SMALLINT(5)`	`NOT NULL`	Position

B.25 POL__SCHEMATA

Table B-25 POL__SCHEMATA Parameters

Column	Datatype	Null	Description
`NAME`	`VARCHAR(128)`	`NOT NULL`	Name
`OWNER`	`VARCHAR(128)`	`NOT NULL`	Owner
`SCHEMA_ID`	`NUMBER(11)`	`NOT NULL`	Schema ID
`CREATED`	`DATE`	`NOT NULL`	Date when created

B.26 POL__SEQ

Table B-26 POL__SEQ Parameters

Column	Datatype	Null	Description
`SCHEMA_NAME`	`VARCHAR(128)`	`NOT NULL`	Schema name
`SEQ_NAME`	`VARCHAR(128)`	`NOT NULL`	Sequence name
`SEQ_REF`	`UNKNOWN(8)`	`NOT NULL`	Sequence reference
`INC_BY`	`NUMBER(10)`	`NOT NULL`	Increment by value
`START_WITH`	`NUMBER(10)`	`NOT NULL`	Number to start sequence with
`MIN_VALUE`	`NUMBER(10)`	`NOT NULL`	Minimum value for sequence
`MAX_VALUE`	`NUMBER(10)`	`NOT NULL`	Maximum value for sequence
`IS_ACCESSED`	`TINYINT(3)`	`NOT NULL`	if accessed

B.27 POL__SYNONYM

Table B-27 POL__SYNONYM Parameters

Column	Datatype	Null	Description
`SYN`	`VARCHAR(128)`	`NOT NULL`	Synonym
`OBJECT`	`VARCHAR(128)`	`NOT NULL`	Object

B.28 POL__TBLCONS

Table B-28 POL__TBLCONS Parameters

Column	Datatype	Null	Description
`CATALOG`	`VARCHAR(128)`	`NOT NULL`	Fully qualified database file name
`SCHEMA`	`VARCHAR(128)`	`NOT NULL`	Schema
`TABLE`	`VARCHAR(128)`	`NOT NULL`	Table
`CONSREF`	`UNKNOWN(8)`	`NOT NULL`	Reference to POL__CONS object
`FLAGS`	`NUMBER(11)`	`NOT NULL`	Reserved
`TYPE`	`NUMBER(11)`	`NOT NULL`	Type
`SEARCH`	`VARCHAR(128)`	`NOT NULL`	Used by Check constraint to store user constraint string
`SEARCHTREE`	`TINYINT(3)`	`NOT NULL`	Internal representation of constraint clause
`EXTENSIONS`	`TINYINT(3)`	`NOT NULL`	Not used
`CLASSREF`	`UNKNOWN(8)`	`NOT NULL`	Reference to Class Object for the table
`GROUPREF`	`UNKNOWN(8)`	`NOT NULL`	Reference to Group Object for the table

B.29 POL__TBLUSAGE

Table B-29 POL_TBLUSAGE Parameters

Column	Datatype	Null	Description
`CATALOG`	`VARCHAR(128)`	`NOT NULL`	Catalog
`SCHEMA`	`VARCHAR(128)`	`NOT NULL`	Schema
`TABLE`	`VARCHAR(128)`	`NOT NULL`	Table
`TBLCONSREF`	`UNKNOWN(8)`	`NOT NULL`	Reference to POL__TBLCONS Object
`DOMCONSREF`	`UNKNOWN(8)`	`NOT NULL`	Not used
`ASSERTCONSREF`	`UNKNOWN(8)`	`NOT NULL`	Not used
`EXTENSIONS`	`TINYINT(3)`	`NOT NULL`	Not used

B.30 POL__TRIGGERS

Table B-30 POL__TRIGGERS Parameters

Column	Datatype	Null	Description
`TRIGGER_NAME`	`VARCHAR(128)`	`NOT NULL`	Trigger name
`TABLE_CLASS`	`UNKNOWN(8)`	`NOT NULL`	Table class
`TRIGGER_KIND`	`SMALLINT(5)`	`NOT NULL`	Trigger kind
`METHOD`	`UNKNOWN(8)`	`NOT NULL`	Method

B.31 POL__VIEWS

Table B-31 POL__VIEWS Parameters

Column	Datatype	Null	Description
`NAME`	`VARCHAR(30)`	`NOT NULL`	View name
`VIEWDEF`	`VARCHAR(128)`	`NOT NULL`	View definition
`POSMAPS`	`NUMBER(11)`	`NOT NULL`	Position Map

B.32 POL__USERS

Table B-32 POL__USERS Parameters

Column	Datatype	Null	Description
`USERNAME`	`VARCHAR(30)`	`NOT NULL`	User name
`PASSWORD`	`VARCHAR(30)`	`NOT NULL`	Password
`USER_ID`	`NUMBER(11)`	`NOT NULL`	User ID
`CREATED`	`DATE`	`NOT NULL`	Date when created