Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP with replication problem.....
Alistair Thomson wrote:
>
> I want to set up an updatable snapshot. So far I've created a master
> site and snapshot site with db links that work.
>
> On the master site I've created a GROUP, put an object into the group
> and generated the replication support without any error messages.
> However when I query the user_repobject table I get a status of ERROR
> for the trigger (see below)
>
> SQL> select sname, oname, type, status, gname from user_repobject;
>
> sname oname type status gname
> ------------------------------------------------------
> alit places table valid groupd
> alit places$rp package valid groupd
> alit places$rp package body valid groupd
> alit places$rr package valiid groupd
> alit places$rr package body valid groupd
> alit places$rt trigger error groupd
>
> I'd be grateful if anyone could help me out with this. Please e-mail
> replies to:-
>
> alit_at_levelv.co.uk
You can recompile the trigger and check user_errors table to see taht is the problem.
alter trigger places$rt compile;
select text from user_errors where name = 'places$rt';
Received on Wed Apr 30 1997 - 00:00:00 CDT