Re: oracle streams error

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:4023cdba$0$28167$626a14ce_at_news.free.fr...
>
> "Cookie Monster" <cookie.monster_at_somewhere.com> a écrit dans le message de
> news:c00cp6$118s3i$1_at_ID-82797.news.uni-berlin.de...
> > Hi,
> >
> > I'm getting this error in the apply (dest) database:
> >
> > ORA-26687: no instantiation SCN provided
> >
> > Anyone know what it means and how I can fix it. I tried to figure out
which
> > object causes the problem but the docs are a nightmare.
> >
> > Thanks,
> > cookie.
> >
>
> ORA-26687 no instantiation SCN provided
> Cause: Object SCN has not been set.
> Action: Set the SCN by calling DBMS_APPLY_ADM.SET_INSTANTIATION_SCN.
>
> See Section "Setting Instantiation SCNs at a Destination Database"
> in Chapter 13 "Managing an Apply Process" of "Oracle9i Streams" book.
>
> Regards
> Michel Cadot
>

Unfortantly no such package exists in 9.2.0.4. I guess you need to specify the table, but how can I determine which table to instantiate?

cookie. Received on Tue Feb 03 2004 - 04:20:13 CST