C Catalog Views for the Mobile Server

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.

C.1 CV$ALL_CLIENTS

The CV$ALL_CLIENTS view provides information about mobile clients.

Table C-1 provides a description of ALL_CLIENT parameters.

Table C-1 ALL_CLIENTS Parameters

Column Datatype Null Description

CLIENT

VARCHAR2(60)

NOT NULL

The mobile client

LASTREFRESH_STARTIME

VARCHAR2(19)

NULL

Start time of the last refresh session

LASTREFRESH_ENDTIME

VARCHAR2(19)

NULL

End time of the last refresh session


C.2 CV$ALL_ERRORS

The CV$ALL_ERRORS view provides information about failed client transactions.

Table C-2 provides a description of ALL_ERRORS parameters.

Table C-2 ALL_ERRORS Parameters

Column Datatype Null Description

CLIENT

VARCHAR2(60)

NOT NULL

Client to which the failed transaction belongs.

TRANSACTION_ID

NUMBER(10)

NOT NULL

ID of the failed transaction.

ITEM_NAME

VARCHAR2(30)

NULL

Name of the publication item that failed.

MESSAGE_TEXT

VARCHAR2(2048)

NULL

Error text associated with the failed transaction and publication item.


C.3 CV$ALL_PUBLICATIONS

The ALL_PUBLICATIONS view provides information about mobile server publications.

Table C-3 provides a description of ALL_PUBLICATIONS parameters.

Table C-3 ALL_PUBLICATIONS Parameters

Column Datatype Null Description

NAME

VARCHAR2(30)

NOT NULL

Publication Name.

TYPE

VARCHAR2(40)

NULL

Publication Type.

NAME_TEMPLATE

VARCHAR2(30)

NULL

Snapshot Name Template.

ENFORCE_RI

CHAR(1)

NOT NULL

Reserved.


C.4 CV$ALL_SUBSCRIPTIONS

The ALL_SUBSCRIPTIONS view provides information about mobile server subscriptions.

Table C-4 provides a description of ALL_SUBSCRIPTIONS parameters.

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


C.5 CV$ALL_SEQUENCES

The ALL_SEQUENCES view provides information about mobile server sequences.

Table C-5 provides a description of ALL_SEQUENCES parameters.

Table C-5 ALL_SEQUENCES Parameters

Column Datatype Null Description

NAME

VARCHAR2(30)

NOT NULL

The sequence name.


C.6 CV$ALL_SEQUENCE_PARTITIONS

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

CLIENT

VARCHAR2(60)

NOT NULL

The client to which the sequence is assigned.

NAME

VARCHAR2(30)

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


C.7 CV$ALL_PUBLICATION_ITEMS_ADDED

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

PUB_NAME

VARCHAR2(30)

NOT NULL

The publication name.

ITEM_NAME

VARCHAR2(30)

NOT 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

CLOB

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

WINNING_RULE

VARCHAR2(30)

NULL

The winning rules option for resolving replication conflicts. Options include "client wins" and "server wins".


C.8 CV$ALL_PUBLICATION_ITEMS

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 Null Description

NAME

VARCHAR2(30)

NOT 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

CLOB

NULL

The select statement.

REFRESH_METHOD

CHAR(1)

NOT NULL

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.


C.9 CV$ALL_PUBLICATION_INDEXES

The ALL_PUBLICATION_INDEXES view provides information about mobile server publication item indexes.

Table C-9 provides a description of ALL_PUBLICATION_INDEXES parameters.

Table C-9 ALL_PUBLICATION_INDEXES Parameters

Column Datatype Null Description

NAME

VARCHAR2(30)

NOT NULL

Index name.

PUB_ITEM

VARCHAR2(30)

NULL

Publication item name.

INDX_TYPE

CHAR(1)

NULL

Index type.

COLUMN_LIST

VARCHAR2(2048)

NULL

Column list.


C.10 CV$ALL_SUBSCRIPTION_PARAMS

The ALL_SUBSCRIPTION_PARAMS view provides information about mobile server subscription parameters.

Table C-10 provides a description of ALL_SUBSCRIPTION_PARAMS parameters.

Table C-10 ALL_SUBSCRIPTION_PARAMS Parameters

Column Datatype Null Description

NAME

VARCHAR2(30)

NOT NULL

Publication name.

CLIENT

VARCHAR2(60)

NOT NULL

Client name.

PARAM_NAME

VARCHAR2(30)

NOT NULL

Parameter name.

PARAM_VALUE

VARCHAR2(62)

NULL

Parameter value.