Skip Headers
Oracle® Database Lite Administration and Deployment Guide
10g (10.3.0)

Part Number B28922-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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:

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.

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

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

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