This document is a reference to system catalog views for the Mobile Admin schema. The following section lists and describes 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 views include:
The "MOBILEADMIN".CV$ALL_CLIENTS
view provides information about Mobile Server clients.
Table F-1 provides a description of ALL_CLIENT
parameters.
The "MOBILEADMIN".CV$ALL_ERROR
view provides information about failed client transactions.
Table F-2 provides a description of ALL_ERROR
parameters.
Table F-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. |
The ALL_PUBLICATIONS
view provides information about Mobile Server publications.
Table F-3 provides a description of ALL_PUBLICATIONS
parameters.
The ALL_SUBSCRIPTIONS
view provides information about Mobile Server subscriptions.
Table F-4 provides a description of ALL_SUBSCRIPTION
parameters.
The ALL_SEQUENCES
view provides information about Mobile Server sequences.
Table F-5 provides a description of ALL_SEQUENCES
parameters.
The ALL_SEQUENCE_PARTITIONS
view provides information about Mobile Server sequence partitions.
Table F-6 provides a description of ALL_SEQUENCE_PARTITIONS
parameters.
Table F-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. |
The ALL_PUBLICATION_ITEMS_ADDED
view provides information about Mobile Server publication items.
Table F-7 provides a description of ALL_PUBLICATION_ITEMS_ADDED
parameters.
Table F-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: You cannot use fast refresh synchronization with high priority restricting predicate. |
WINNING_RULE |
VARCHAR2(30) |
NULL |
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 F-8 provides a description of ALL_PUBLICATION_ITEMS
parameters.
Table F-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: You cannot use fast refresh synchronization with high priority restricting predicate. |
The ALL_PUBLICATION_ITEM_INDEXES
view provides information about Mobile Server publication item indexes.
Table F-9 provides a description of ALL_PUBLICATION_ITEM_INDEXES
parameters.
The ALL_SUBSCRIPTION_PARAMS
view provides information about Mobile Server subscription parameters.
Table F-10 provides a description of ALL_SUBSCRIPTION_PARAMS
parameters.