The following sections are a reference for the system catalog views for the Mobile Admin schema 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 clients.
Table C-1 provides a description of ALL_CLIENT
parameters.
The CV$ALL_ERROR
view provides information about failed client transactions.
Table C-2 provides a description of ALL_ERROR
parameters.
Table C-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 C-3 provides a description of ALL_PUBLICATIONS
parameters.
The ALL_SUBSCRIPTIONS
view provides information about mobile server subscriptions.
Table C-4 provides a description of ALL_SUBSCRIPTION
parameters.
The ALL_SEQUENCES
view provides information about mobile server sequences.
Table C-5 provides a description of ALL_SEQUENCES
parameters.
The ALL_SEQUENCE_PARTITIONS
view provides information about mobile server sequence partitions.
Table C-6 provides a description of ALL_SEQUENCE_PARTITIONS
parameters.
Table C-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 C-7 provides a description of ALL_PUBLICATION_ITEMS_ADDED
parameters.
Table C-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. 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. |
|
|
|
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 C-8 provides a description of ALL_PUBLICATION_ITEMS
parameters.
Table C-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. 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. |
The ALL_PUBLICATION_ITEM_INDEXES
view provides information about mobile server publication item indexes.
Table C-9 provides a description of ALL_PUBLICATION_ITEM_INDEXES
parameters.
The ALL_SUBSCRIPTION_PARAMS
view provides information about mobile server subscription parameters.
Table C-10 provides a description of ALL_SUBSCRIPTION_PARAMS
parameters.