Re: Replicating Table Setup

You are correct. Defaults are not automatically replicated to updateable snapshots (i.e. which you refer to as the 'updateable view ... on the slave')

You can find this in pub'n A76959-01 (Oracle 8i Replication) on page 3-22:

"Note: An updateable snapshot based on a master table that has defined column default values does not automatically use the master table’s default values.
Note: Updateable snapshots do not support the DELETE CASCADE constraint."

You will have to 'manually' add the defaults or create some automated mechanism (PL/SQL, etc) to replicate these constraints when you create the snapshots.

This was also true with Oracle 8.

Steve Parfitt

Steve James wrote:
>
> Hi,
>
> I have recently setup up a master/slave replicated environment, but have
> noticed that the tables in
> the slave environment don't carry across attributes such as default values.
> i.e. if I create a table:
>
> create table test(
> mytext varchar2(10),
> mynumber default 2));
>
> on the master site, and this table is replicated onto the slave as an
> updateable view, when I try and insert the row on the slave:
>
> insert into test (mytext) values ('test1');
>
> The default value criteria is ignored.
> i.e.
> select * from test
>
> Mytext Mynumber
> --------- --------------
> test1
>
> is should read
>
> Mytext Mynumber
> ------- --------------
> test1 2
>
> Can anybody tell me what is going on and how I can get this criteria across?
>
> Cheers,
>
> Steve
Received on Wed Sep 12 2001 - 11:24:10 CDT