The following sections describe the catalog views for the Mobile Server and the Mobile client:
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.
The CV$ALL_CLIENTS
view provides information about Mobile Server clients.
Table D-1 provides a description of ALL_CLIENT
parameters.
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 to which the failed transaction belongs. |
|
|
|
ID of the failed transaction. |
|
|
|
Name of the publication item that failed. |
|
|
|
Error text associated with the failed transaction and publication item. |
The ALL_PUBLICATIONS
view provides information about Mobile Server publications.
Table D-3 provides a description of ALL_PUBLICATIONS
parameters.
The ALL_SUBSCRIPTIONS
view provides information about Mobile Server subscriptions.
Table D-4 provides a description of ALL_SUBSCRIPTION
parameters.
The ALL_SEQUENCES
view provides information about Mobile Server sequences.
Table D-5 provides a description of ALL_SEQUENCES
parameters.
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 |
---|---|---|---|
|
|
|
The client to which the sequence is assigned. |
|
|
|
The sequence name. |
|
|
|
The current sequence value. |
|
|
|
The sequence's increment value. The sequence increments based on this number. |
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 |
---|---|---|---|
|
|
|
The publication name. |
|
|
|
The publication item name. |
|
|
|
The base object owner. |
|
|
|
The base object name. |
|
|
|
The select statement. |
|
|
|
The updatable option. |
|
|
|
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. |
|
|
|
The winning rules option for resolving replication conflicts. Options include "client wins" and "server wins". |
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 |
---|---|---|---|
|
|
|
The publication item name. |
|
|
|
The owner of the publication items' base object. |
|
|
|
Name of the base object. |
|
|
|
The select statement. |
|
|
|
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. |
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.
The ALL_SUBSCRIPTION_PARAMS
view provides information about Mobile Server subscription parameters.
Table D-10 provides a description of ALL_SUBSCRIPTION_PARAMS
parameters.
The following are the SQLRT and other system catalogs that are included in the client Oracle Lite database:
Table D-12 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 D-14 ALL_DEPENDENCIES Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Owner |
|
|
|
Name |
|
|
|
Type |
|
|
|
Referenced owner |
|
|
|
Referenced name |
|
|
|
Referenced type |
Table D-15 ALL_INDEXES Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Owner |
|
|
|
Index name |
|
|
|
Table owner |
|
|
|
Table name |
|
|
|
Table type |
|
|
|
Index Uniqueness |
Table D-16 ALL_IND_COLUMNS Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Index owner |
|
|
|
Index name |
|
|
|
Table owner |
|
|
|
Table name |
|
|
|
Column name |
|
|
|
Column position |
Table D-18 ALL_PRIVILEGES Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Schema |
|
|
|
Table |
|
|
|
Column |
|
|
|
Grantor |
|
|
|
Grantee |
|
|
|
Object type |
|
|
|
Grant type |
|
|
|
Grant table |
|
|
|
Not used |
Table D-19 ALL_SEQUENCES Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Sequence owner |
|
|
|
Sequence name |
|
|
|
Minimum value |
|
|
|
Maximum value |
|
|
|
Increment value for sequence |
Table D-21 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 D-22 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 D-26 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 D-29 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 D-31 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 D-32 POL__INDICESDT Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Column name |
|
|
|
Ascending or descending direction |
|
|
|
Relative position in index |
|
|
|
Master index table |
|
|
|
Not used |
Table D-33 POL__PROCEDURES Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Catalog name |
|
|
|
Schema name |
|
|
|
Procedure name |
|
|
|
Table class |
|
|
|
Procedure type |
|
|
|
Procedure reference |
Table D-34 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 D-36 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 D-38 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 D-39 POL_TBLUSAGE Parameters
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Catalog |
|
|
|
Schema |
|
|
|
Table |
|
|
|
Reference to POL__TBLCONS Object |
|
|
|
Not used |
|
|
|
Not used |
|
|
|
Not used |