H
System Catalog Views

This document is a reference to the system catalog views for the Mobile Admin schema. This appendix covers the following set of catalog views:

Mobile Server Catalog Views

H.1 Mobile Server Catalog Views

This document is a reference for the system catalog views which are part of the Mobile Admin schema which is installed as part of Mobile Server. The Mobile Admin schema is not part of the Mobile Development Kit.

The views are read-only and should not be modified. The views include:

H.1.1 "MOBILEADMIN".CV$ALL_CLIENTS

This view provides information about Mobile Server clients, columns include:

Table H-1 ALL_CLIENTS Parameters

Column	Datatype	Description
CLIENT	VARCHAR2(30)	The Mobile Server client.
LASTREFRESH_STARTTIME	VARCHAR2(19)	The start time of the last refresh.
LASTREFRESH_ENDTIME	VARCHAR2(19)	The end time of the last refresh.

H.1.2 "MOBILEADMIN".CV$ALL_ERROR

This view provides information about failed Mobile Server transactions, columns include:

Table H-2 ALL_ERROR Parameters

Column	Datatype	Null	Description
CLIENT	VARCHAR2(30)	NOT NULL	The client to which the failed transaction belongs.
TRANSACTION_ID	NUMBER(10)	NOT NULL	ID of the failed transaction.
ITEM_NAME	VARCHAR2(30)		Name ofthe publication item that failed.
MESSAGE_TEXT	VARCHAR2(2048)		Error text associated with the failed transaction and publication item.

H.1.3 "MOBILEADMIN".CV$ALL_PUBLICATIONS

This view provides information about Mobile ServerMobile Server publications, columns include:

Table H-3 ALL_PUBLICATIONS Parameters

Column	Datatype	Null	Description
NAME	VARCHAR2(30)		The publication name.
TYPE	VARCHAR2(40)		The publication type.
NAME_TEMPLATE	VARCHAR2(30)		The snapshot name template.
ENFORCE_RI	CHAR(1)	NOT NULL	Reserved.

H.1.4 "MOBILEADMIN".CV$ALL_SUBSCRIPTIONS

This view provides information about Mobile Server subscriptions, columns include:

Table H-4 ALL_SUBSCRIPTIONS Parameters

Column	Datatype	Description
CLIENT	VARCHAR2(30)	The subscription's clients.
PUBLICATION	VARCHAR2(30)	The subscription's publication.
INSTANTIATED	CHAR(1)	A Boolean value that indicates whether the subscription is instantiated.

H.1.5 "MOBILEADMIN".CV$ALL_SEQUENCES

This view provides information about Mobile Server sequences, columns include:

Table H-5 ALL_SEQUENCES Parameters

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

H.1.6 "MOBILEADMIN".CV$ALL_SEQUENCE_PARTITIONS

This view provides information about Mobile Server sequence partitions, columns include:

Table H-6 ALL_SEQUENCE_PARTITIONS Parameters

Column	Datatype	Description
CLIENT	VARCHAR2(30)	The client to which the sequence is assigned.
NAME	VARCHAR2(30)	The sequence name.
CURR_VALUE	NUMBER(38)	The current sequence value.
INCREMENT_BY	NUMBER(38)	The sequence's increment value. The sequence increments by this number.

H.1.7 "MOBILEADMIN".CV$ALL_PUBLICATION_ITEMS_ADDED

This view provides information about Mobile Server publication items added to publications, columns include:

Table H-7 ALL_PUBLICATION_ITEMS_ADDED Parameters

Column	Datatype	Null	Description
PUB_NAME	VARCHAR2(30)		The publication name.
ITEM_NAME	VARCHAR2(30)		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)		The updatable option.
REFRESH_METHOD	CHAR(1)	NOT NULL	The refresh method. Options include fast refresh and complete refresh.
WINNING_RULE	VARCHAR2(30)		The winning rules option for resolving replication conflicts. Options include "client wins" and "server wins".

H.1.8 "MOBILEADMIN".CV$ALL_PUBLICATION_ITEMS

This view provides information about Mobile Server publication items, columns include:

Table H-8 ALL_PUBLICATION_ITEMS Parameters

Column	Datatype	Null	Description
NAME	VARCHAR2(30)		The publication item name.
OWNER	VARCHAR2(30)	NOT NULL	The owner of the publication item's base object.
OBJECT_NAME	VARCHAR2(30)	NOT NULL	The 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.

H.1.9 "MOBILEADMIN".CV$ALL_PUBLICATION_INDEXES

This view provides information about Mobile Server publication indexes, columns include:

Table H-9 ALL_PUBLICATION_INDEXES Parameters

Column	Datatype	Null	Description
NAME	VARCHAR2(30)		The index name.
PUB_ITEM	VARCHAR2(30)	NOT NULL	The publication item name.
INDX_TYPE	CHAR(1)	NOT NULL	The index type.
COLUMN_LIST	VARCHAR2(2048)	NOT NULL	The column list.

H.1.10 "MOBILEADMIN".CV$ALL_SUBSCRIPTION_PARAMS

This view provides information about Mobile Server subscription parameters, columns include:

Table H-10 ALL_SUBSCRIPTIONS_PARAMS Parameters

Column	Datatype	Description
NAME	VARCHAR2(30)	The publication name.
CLIENT	VARCHAR2(30)	The client.
PARAM_NAME	VARCHAR2(30)	The parameter name.
PARAM_VALUE	VARCHAR2(30)	The parameter value.

H System Catalog Views