F System Catalog Views

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.

F.1 Mobile Server Catalog Views

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:

• Section F.1.1, "ALL_CLIENTS Parameters"

• Section F.1.2, "ALL_ERROR Parameters"

• Section F.1.3, "ALL_PUBLICATIONS Parameters"

• Section F.1.4, "ALL_SUBSCRIPTIONS Parameters"

• Section F.1.5, "ALL_SEQUENCES Parameters"

• Section F.1.6, "ALL_SEQUENCE_PARTITIONS Parameters"

• Section F.1.7, "ALL_PUBLICATION_ITEMS_ADDED Parameters"

• Section F.1.8, "ALL_PUBLICATION_ITEMS Parameters"

• Section F.1.9, "ALL_PUBLICATION_ITEM_INDEXES Parameters"

• Section F.1.10, "ALL_SUBSCRIPTION_PARAMS Parameters"

F.1.1 "MOBILEADMIN".CV$ALL_CLIENTS

The "MOBILEADMIN".CV$ALL_CLIENTS view provides information about Mobile Server clients.

Table F-1 provides a description of ALL_CLIENT parameters.

Table F-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

F.1.2 "MOBILEADMIN".CV$ALL_ERROR

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.

F.1.3 "MOBILEADMIN".CV$ALL_PUBLICATIONS

The ALL_PUBLICATIONS view provides information about Mobile Server publications.

Table F-3 provides a description of ALL_PUBLICATIONS parameters.

Table F-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.

F.1.4 "MOBILEADMIN".CV$ALL_SUBSCRIPTIONS

The ALL_SUBSCRIPTIONS view provides information about Mobile Server subscriptions.

Table F-4 provides a description of ALL_SUBSCRIPTION parameters.

Table F-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.

F.1.5 "MOBILEADMIN".CV$ALL_SEQUENCES

The ALL_SEQUENCES view provides information about Mobile Server sequences.

Table F-5 provides a description of ALL_SEQUENCES parameters.

Table F-5 ALL_SEQUENCES Parameters

Column	Datatype	Null	Description
NAME	VARCHAR2(30)	NULL	The sequence name.

F.1.6 "MOBILEADMIN".CV$ALL_SEQUENCE_PARTITIONS

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.

F.1.7 "MOBILEADMIN".CV$ALL_PUBLICATION_ITEMS_ADDED

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".

F.1.8 "MOBILEADMIN".CV$ALL_PUBLICATION_ITEMS

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.

F.1.9 "MOBILEADMIN".CV$ALL_PUBLICATION_ITEM_INDEXES

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.

Table F-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.

F.1.10 " MOBILEADMIN".CV.$ALL_SUBSCRIPTION_PARAMS

The ALL_SUBSCRIPTION_PARAMS view provides information about Mobile Server subscription parameters.

Table F-10 provides a description of ALL_SUBSCRIPTION_PARAMS parameters.

Table F-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.