Thanks Steve, I have now created a script to alter tables to create default
values.
"Stephen T. Parfitt" <steve.parfitt_at_sympatico.ca> wrote in message
news:3B9F8C2A.43E9055E_at_sympatico.ca...
> 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 Thu Sep 13 2001 - 01:14:05 CDT
