D Catalog Views for the Mobile Server and the Mobile Client

The following sections describe the catalog views for the Mobile Server and the Mobile client:

Section D.1, "Mobile Server System Catalog Views"
Section D.2, "Client Oracle Lite Database System Catalogs"

D.1 Mobile Server System Catalog Views

The following sections are a reference for the system catalog views for the Mobile Admin schema. These sections list and describe the complete set of catalog views for the Mobile Server.

The Mobile Admin schema is installed as part of the Mobile Server during installation. However, the Mobile Admin schema is not part of the Mobile Development Kit.

The system catalog views are read-only and should not be modified.

Section D.1.1, "CV$ALL_CLIENTS"
Section D.1.2, "CV$ALL_ERROR"
Section D.1.3, "CV$ALL_PUBLICATIONS"
Section D.1.4, "CV$ALL_SUBSCRIPTIONS"
Section D.1.5, "CV$ALL_SEQUENCES"
Section D.1.6, "CV$ALL_SEQUENCE_PARTITIONS"
Section D.1.7, "CV$ALL_PUBLICATION_ITEMS_ADDED"
Section D.1.8, "CV$ALL_PUBLICATION_ITEMS"
Section D.1.9, "CV$ALL_PUBLICATION_ITEM_INDEXES"
Section D.1.10, "CV.$ALL_SUBSCRIPTION_PARAMS"

D.1.1 CV$ALL_CLIENTS

The CV$ALL_CLIENTS view provides information about Mobile Server clients.

Table D-1 provides a description of ALL_CLIENT parameters.

Table D-1 ALL_CLIENTS Parameters

Column	Datatype	Null	Description
`CLIENT`	`VARCHAR(30)`	`NULL`	The Mobile Server client
`LASTREFRESH_STARTIME`	`VARCHAR(19)`	`NULL`	Start time of the last refresh session
`LASTREFRESH_ENDTIME`	`VARCHAR(19)`	`NULL`	End time of the last refresh session

D.1.2 CV$ALL_ERROR

The CV$ALL_ERROR view provides information about failed client transactions.

Table D-2 provides a description of ALL_ERROR parameters.

Table D-2 ALL_ERROR Parameters

Column	Datatype	Null	Description
`CLIENT`	`VARCHAR(30)`	`NOT NULL`	Client to which the failed transaction belongs.
`TRANSACTION_ID`	`NUMBER(10)`	`NOT NULL`	ID of the failed transaction.
`ITEM_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the publication item that failed.
`MESSAGE_TEXT`	`VARCHAR2(2048)`	`NOT NULL`	Error text associated with the failed transaction and publication item.

D.1.3 CV$ALL_PUBLICATIONS

The ALL_PUBLICATIONS view provides information about Mobile Server publications.

Table D-3 provides a description of ALL_PUBLICATIONS parameters.

Table D-3 ALL_PUBLICATIONS Parameters

Column	Datatype	Null	Description
`NAME`	`VARCHAR2(30)`	`NULL`	Publication Name.
`TYPE`	`VARCHAR2(40)`	`NULL`	Publication Type.
`NAME_TEMPLATE`	`VARCHAR2(30)`	`NULL`	Snapshot Name Template.
`ENFORCE_RI`	`CHAR(1)`	`NOT NULL`	Reserved.

D.1.4 CV$ALL_SUBSCRIPTIONS

The ALL_SUBSCRIPTIONS view provides information about Mobile Server subscriptions.

Table D-4 provides a description of ALL_SUBSCRIPTION parameters.

Table D-4 ALL_SUBSCRIPTIONS Parameters

Column	Datatype	Null	Description
`CLIENT`	`VARCHAR2(30)`	`NULL`	The subscription's clients.
`PUBLICATION`	`VARCHAR2(30)`	`NULL`	The subscription's publication.
`INSTANTIATED`	`CHAR(1)`	`NULL`	A boolean value that indicates whether the subscription is instantiated.

D.1.5 CV$ALL_SEQUENCES

The ALL_SEQUENCES view provides information about Mobile Server sequences.

Table D-5 provides a description of ALL_SEQUENCES parameters.

Table D-5 ALL_SEQUENCES Parameters

Column	Datatype	Null	Description
`NAME`	`VARCHAR2(30)`	`NULL`	The sequence name.

D.1.6 CV$ALL_SEQUENCE_PARTITIONS

The ALL_SEQUENCE_PARTITIONS view provides information about Mobile Server sequence partitions.

Table D-6 provides a description of ALL_SEQUENCE_PARTITIONS parameters.

Table D-6 ALL_SEQUENCE_PARTITIONS Parameters

Column	Datatype	Null	Description
`CLIENT`	`VARCHAR2(30)`	`NULL`	The client to which the sequence is assigned.
`NAME`	`VARCHAR2(30)`	`NULL`	The sequence name.
`CURR_VALUE`	`NUMBER(38)`	`NULL`	The current sequence value.
`INCREMENT_BY`	`NUMBER(38)`	`NULL`	The sequence's increment value. The sequence increments based on this number.

D.1.7 CV$ALL_PUBLICATION_ITEMS_ADDED

The ALL_PUBLICATION_ITEMS_ADDED view provides information about Mobile Server publication items.

Table D-7 provides a description of ALL_PUBLICATION_ITEMS_ADDED parameters.

Table D-7 ALL_PUBLICATION_ITEMS_ADDED Parameters

Column	Datatype	Null	Description
`PUB_NAME`	`VARCHAR2(30)`	`NULL`	The publication name.
`ITEM_NAME`	`VARCHAR2(30)`	`NULL`	The publication item name.
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	The base object owner.
`OBJECT_NAME`	`VARCHAR2(30)`	`NOT NULL`	The base object name.
`TEXT`	`VARCHAR2(2048)`	`NOT NULL`	The select statement.
`UPDATABLE`	`VARCHAR2(1)`	`NULL`	The updatable option.
`REFRESH_METHOD`	`CHAR(1)`	`NOT NULL`	The refresh method. Options include fast refresh and complete refresh. Note: If you use complete refresh, it erases all of the data on the client and brings down the snapshot from the server. If your publication item is updateable, this does not cause a loss of data on the client. If you use fast refresh, then you cannot use a high priority restricting predicate.
`WINNING_RULE`	`VARCHAR2(30)`	`NULL`	The winning rules option for resolving replication conflicts. Options include "client wins" and "server wins".

D.1.8 CV$ALL_PUBLICATION_ITEMS

The ALL_PUBLICATION_ITEMS view provides information about Mobile Server publication items.

Table D-8 provides a description of ALL_PUBLICATION_ITEMS parameters.

Table D-8 ALL_PUBLICATION_ITEMS Parameters

Column	Datatype	Type	Description
`NAME`	`VARCHAR2(30)`	`NULL`	The publication item name.
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	The owner of the publication items' base object.
`OBJECT_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the base object.
`TEXT`	`VARCHAR2(2048)`	`NOT NULL`	The select statement.
`REFRESH_METHOD`	`CHAR(1)`	`NOT NULL`	The refresh method. Options include fast refresh and complete refresh. Note: If you use complete refresh, it erases all of the data on the client and brings down the snapshot from the server. If your publication item is updateable, this does not cause a loss of data on the client. If you use fast refresh, then you cannot use a high priority restricting predicate.

D.1.9 CV$ALL_PUBLICATION_ITEM_INDEXES

The ALL_PUBLICATION_ITEM_INDEXES view provides information about Mobile Server publication item indexes.

Table D-9 provides a description of ALL_PUBLICATION_ITEM_INDEXES parameters.

Table D-9 ALL_PUBLICATION_ITEM_INDEXES Parameters

Column	Datatype	Null	Description
`NAME`	`VARCHAR2(30)`	`NULL`	Index name.
`PUB_ITEM`	`VARCHAR2(30)`	`NOT NULL`	Publication item name.
`INDX_TYPE`	`CHAR(1)`	`NOT NULL`	Index type.
`COLUMN_LIST`	`VARCHAR2(2048)`	`NOT NULL`	Column list.

D.1.10 CV.$ALL_SUBSCRIPTION_PARAMS

The ALL_SUBSCRIPTION_PARAMS view provides information about Mobile Server subscription parameters.

Table D-10 provides a description of ALL_SUBSCRIPTION_PARAMS parameters.

Table D-10 ALL_SUBSCRIPTION_PARAMS Parameters

Column	Datatype	Null	Description
`NAME`	`VARCHAR2(30)`	`NULL`	Publication name.
`CLIENT`	`VARCHAR2(30)`	`NULL`	Client name.
`PARAM_NAME`	`VARCHAR2(30)`	`NULL`	Parameter name.
`PARAM_VALUE`	`VARCHAR2(30)`	`NULL`	Parameter value.

D.2 Client Oracle Lite Database System Catalogs

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

Section D.2.1, "ALL_COL_COMMENTS"
Section D.2.2, "ALL_CONSTRAINTS"
Section D.2.3, "ALL_CONS_COLUMNS"
Section D.2.4, "ALL_DEPENDENCIES"
Section D.2.5, "ALL_INDEXES"
Section D.2.6, "ALL_IND_COLUMNS"
Section D.2.7, "ALL_OBJECTS"
Section D.2.8, "ALL_PRIVILEGES"
Section D.2.9, "ALL_SEQUENCES"
Section D.2.10, "ALL_SYNONYMS"
Section D.2.11, "ALL_TABLES"
Section D.2.12, "ALL_TAB_COLUMNS"
Section D.2.13, "ALL_TAB_COMMENTS"
Section D.2.14, "ALL_USERS"
Section D.2.15, "ALL_VIEWS"
Section D.2.16, "POL__ALLOBJ"
Section D.2.17, "POL__COLUSAGE"
Section D.2.18, "POL__COMMENT"
Section D.2.19, "POL__CONS"
Section D.2.20, "POL__DATABASE_PARAMETERS"
Section D.2.21, "POL__INDICES"
Section D.2.22, "POL__INDICESDT"
Section D.2.23, "POL__PROCEDURES"
Section D.2.24, "POL__PROCEDURE_COLUMNS"
Section D.2.25, "POL__SCHEMATA"
Section D.2.26, "POL__SEQ"
Section D.2.27, "POL__SYNONYM"
Section D.2.28, "POL__TBLCONS"
Section D.2.29, "POL__TBLUSAGE"
Section D.2.30, "POL__TRIGGERS"
Section D.2.31, "POL__VIEWS"
Section D.2.32, "POL__USERS"

D.2.1 ALL_COL_COMMENTS

Table D-11 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

D.2.2 ALL_CONSTRAINTS

Table D-12 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

D.2.3 ALL_CONS_COLUMNS

Table D-13 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

D.2.4 ALL_DEPENDENCIES

Table D-14 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

D.2.5 ALL_INDEXES

Table D-15 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

D.2.6 ALL_IND_COLUMNS

Table D-16 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

D.2.7 ALL_OBJECTS

Table D-17 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

D.2.8 ALL_PRIVILEGES

Table D-18 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

D.2.9 ALL_SEQUENCES

Table D-19 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

D.2.10 ALL_SYNONYMS

Table D-20 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

D.2.11 ALL_TABLES

Table D-21 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

D.2.12 ALL_TAB_COLUMNS

Table D-22 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

D.2.13 ALL_TAB_COMMENTS

Table D-23 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

D.2.14 ALL_USERS

Table D-24 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

D.2.15 ALL_VIEWS

Table D-25 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

D.2.16 POL__ALLOBJ

Table D-26 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

D.2.17 POL__COLUSAGE

Table D-27 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

D.2.18 POL__COMMENT

Table D-28 POL__COMMENT Parameters

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

D.2.19 POL__CONS

Table D-29 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

D.2.20 POL__DATABASE_PARAMETERS

Table D-30 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

D.2.21 POL__INDICES

Table D-31 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

D.2.22 POL__INDICESDT

Table D-32 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

D.2.23 POL__PROCEDURES

Table D-33 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

D.2.24 POL__PROCEDURE_COLUMNS

Table D-34 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

D.2.25 POL__SCHEMATA

Table D-35 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

D.2.26 POL__SEQ

Table D-36 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

D.2.27 POL__SYNONYM

Table D-37 POL__SYNONYM Parameters

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

D.2.28 POL__TBLCONS

Table D-38 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

D.2.29 POL__TBLUSAGE

Table D-39 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

D.2.30 POL__TRIGGERS

Table D-40 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

D.2.31 POL__VIEWS

Table D-41 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

D.2.32 POL__USERS

Table D-42 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