Skip Headers
Oracle® Database Lite Administration and Deployment Guide
10g (10.0.0)
Part No. B12262-01
  Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
Next
Next
 

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

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

G.1.1 "MOBILEADMIN".CV$ALL_CLIENTS

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

Table G-1 provides a description of ALL_CLIENT parameters.

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

G.1.2 "MOBILEADMIN".CV$ALL_ERROR

The "MOBILEADMIN.CV$ALL_ERROR view provides information about failed client transactions.

Table G-2 provides a description of ALL_ERROR parameters.

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

G.1.3 "MOBILEADMIN".CV$ALL_PUBLICATIONS

The ALL_PUBLICATIONS view provides information about Mobile Server publications.

Table G-3 provides a description of ALL_PUBLICATIONS parameters.

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

G.1.4 "MOBILEADMIN".CV$ALL_SUBSCRIPTIONS

The ALL_SUBSCRIPTIONS view provides information about Mobile Server subscriptions.

Table G-4 provides a description of ALL_SUBSCRIPTION parameters.

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

G.1.5 "MOBILEADMIN".CV$ALL_SEQUENCES

The ALL_SEQUENCES view provides information about Mobile Server sequences.

Table G-5 provides a description of ALL_SEQUENCES parameters.

Table G-5 ALL_SEQUENCES Parameters

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

G.1.6 "MOBILEADMIN".CV$ALL_SEQUENCE_PARTITIONS

The ALL_SEQUENCE_PARTITIONS view provides information about Mobile Server sequence partitions.

Table G-6 provides a description of ALL_SEQUENCE_PARTITIONS parameters.

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

G.1.7 "MOBILEADMIN".CV$ALL_PUBLICATION_ITEMS_ADDED

The ALL_PUBLICATION_ITEMS_ADDED view provides information about Mobile Server publication items.

Table G-7 provides a description of ALL_PUBLICATION_ITEMS_ADDED parameters.

Table G-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.
WINNING_RULE VARCHAR2(30) NULL The winning rules option for resolving replication conflicts. Options include "client wins" and "server wins".

G.1.8 "MOBILEADMIN".CV$ALL_PUBLICATION_ITEMS

The ALL_PUBLICATION_ITEMS view provides information about Mobile Server publication items.

Table G-8 provides a description of ALL_PUBLICATION_ITEMS parameters.

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

G.1.9 "MOBILEADMIN.CV$ALL_PUBLICATION_ITEM_INDEXES

The ALL_PUBLICATION_ITEM_INDEXES view provides information about Mobile Server publication item indexes.

Table G-9 provides a description of ALL_PUBLICATION_ITEM_INDEXES parameters.

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

G.1.10 " MOBILEADMIN"CV.$ALL_SUBSCRIPTION_PARAMS

The ALL_SUBSCRIPTION_PARAMS view provides information about Mobile Server subscription parameters.

Table G-10 provides a description of ALL_SUBSCRIPTION_PARAMS parameters.

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