(B)0[mmove-views-clause =
qqqq> [4mMOVE[m [4mVIEWS[m qqwqq> [4mALL[m qqqqqqqqqqqwqqq>
mwq> view-name qqwqqj
mqqqqqq , <qqqqqqj
Selects the views Replication Option defines on the target
database during an extraction or a replication transfer. All the
relations, views, and fields on which the transferred views are
based must also be explicitly or implicitly named in the DEFINE
TRANSFER statement. The transfer definition will fail if any
underlying relation, view, or field is not named when you define
the transfer. Note that, if you omit the move-relations-clause,
relations are implicitly named in the transfer definition because
MOVE RELATIONS ALL is the default.
If you specify a view name in this clause, the view definition
is transferred to the target database. You can include only one
move-views-clause in a DEFINE TRANSFER statement. However, you
can specify two or more views in that move-views-clause.
Transferring views is limited by the following restrictions:
o COMPUTED_BY fields
Replication Option transfers those COMPUTED_BY fields that
depend only on the values of the relation in which the field
is defined. Views that contain unsupported COMPUTED_BY fields
cannot be transferred. If views that contain unsupported
COMPUTED_BY fields are specified in the move-views-clause
of a DEFINE TRANSFER statement, the transfer definition fails.
You need to redefine the transfer, excluding the views that
refer to the unsupported COMPUTED_BY fields.
o READ privilege for the view
For a view in an Oracle Rdb database to be transferred, Replication
Option requires that you have Oracle Rdb READ privilege for
the view and for the underlying relations. If you do not have
READ privilege for views you specify in the move-views-clause
of a DEFINE TRANSFER statement, the transfer will fail. You
need to obtain READ privilege for these views before including
them in a DEFINE TRANSFER statement.
For databases accessed through the Rdb Transparent Gateways,
Replication Option does not check for READ privilege for views.
You can also move views with the move-relations-clause. However,
when you use the move-relations-clause to move a view, the view
becomes a relation in the target database.
Additional Information:
explode
extract