Skip Headers

Oracle® Database Lite Administration and Deployment Guide Release 10.3 Part Number E12089-02 |
Home | Book List | Contents | Index | Contact Us

Previous | 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:

- 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. You can only use fast refresh with a high priority restricting predicate. If you use any other type of refresh, the high priority restricting predicate is ignored.
`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. You can only use fast refresh with a high priority restricting predicate. If you use any other type of refresh, the high priority restricting predicate is ignored.

### 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 SQLRT and other system catalogs that are included in the client Oracle Lite database are listed in Appendix B, "Catalogs for the Oracle Lite Client" in the Oracle Database Lite Client Guide.