Re: Replication #2

Bostjan

The definition of ADD_MASTER_DATABASE in 8.0.5 is:

DBMS_REPCAT.ADD_MASTER_DATABASE(

      gname                 IN   VARCHAR2,
      master                IN   VARCHAR2,
      use_existing_objects  IN   BOOLEAN  := TRUE,
      copy_rows             IN   BOOLEAN  := TRUE,
      comment               IN   VARCHAR2 := '',
      propagation_mode      IN   VARCHAR2 := 'ASYNCHRONOUS')

Notice the definition of use_existing_objects - it defaults to TRUE. If you don't have the objects there, it should be set to FALSE. Try that and see what happens.

Pete

Bostjan Stupica wrote:

> Hoj!
>
> We have two Oracle Server EE v8.0.5.1.0 (with patch, like you see). The
> instance names are TST1 and TST2 (for example). Then I build Replication
> Group on TST1 with few tables on one of them, so TST1 is MDS (Master
> Definition Site).
>
> When I say:
> ---
> SQL> EXECUTE DBMS_REPCAT.ADD_MASTER_DATABASE(GNAME => 'TEST',
> MASTER => 'TST2.ixtlan.si',
> PROPAGATION_MODE => 'SYNCHRONOUS');
> ---
> ... I get the following situation:
> - repgroup TEST is quisced on instance TST1 (MDS) ... that's OK
> - repgroup TEST is quisced on instance TST2 ... that's OK
> - on instance TST2 I have no tables (and no data), which should be
> replicated from instance TST1 for replication group TEST ... that's NOT OK.
>
> What did I miss?
>
> Thank you,
>
> Bostjan

Received on Mon Sep 13 1999 - 15:48:12 CDT