RDOHELP72.HLB  —  Replication Option, DEFINE_TRANSFER, Format  move-views-clause
  (B)0move-views-clause =

  qqqq>  MOVE VIEWS  qqwqq>  ALL  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

view-name
Close Help