A
Mobile Server System Catalog

This document is a reference to the Mobile Server 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:

A.1 "MOBILEADMIN".CV$ALL_CLIENTS

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

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.

Table A-1 ALL_CLIENTS Parameters

Column Datatype Null 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.

A.2 "MOBILEADMIN".CV$ALL_PUBLICATIONS

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

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.

Table A-2 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.

A.3 "MOBILEADMIN".CV$ALL_SUBSCRIPTIONS

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

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.

Table A-3 ALL_SUBSCRIPTIONS Parameters

Column Datatype Null 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.

A.4 "MOBILEADMIN".CV$ALL_SEQUENCES

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

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

Table A-4 ALL_SEQUENCES Parameters

Column Datatype Null Description

NAME

VARCHAR2(30)

The sequence name.

A.5 "MOBILEADMIN".CV$ALL_SEQUENCE_PARTITIONS

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

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.

Table A-5 ALL_SEQUENCE_PARTITIONS Parameters

Column Datatype Null 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.

A.6 "MOBILEADMIN".CV$ALL_PUBLICATION_ITEMS_ADDED

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

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

Table A-6 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".

A.7 "MOBILEADMIN".CV$ALL_PUBLICATION_ITEMS

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

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.

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

A.8 "MOBILEADMIN".CV$ALL_PUBLICATION_INDEXES

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

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.

Table A-8 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.

A.9 "MOBILEADMIN".CV$ALL_SUBSCRIPTION_PARAMS

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

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.

Table A-9 ALL_SUBSCRIPTIONS_PARAMS Parameters

Column Datatype Null 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.

A Mobile Server System Catalog