Re: oracle streams error

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:4024fa34$0$28161$626a14ce_at_news.free.fr...
>
> "Cookie Monster" <NOSAM_at_gmx.net> a écrit dans le message de
> news:c02ea3$12gon5$1_at_ID-82797.news.uni-berlin.de...
> > "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.
> >
>
> Oracle9i Supplied PL/SQL Packages and Types Reference Release 2 (9.2)
> Chapter 4: DBMS_APPLY_ADM
>
> Summary of DBMS_APPLY_ADM Subprograms
> ...
> "SET_SCHEMA_INSTANTIATION_SCN Procedure"
> Records the specified instantiation SCN for the specified schema in the
specified source database
> "SET_TABLE_INSTANTIATION_SCN Procedure"
> Records the specified instantiation SCN for the specified table in the
specified source database
> ...
>

Thanks! Somehow that section was missing from my PDF printout. Think I can figure out now.

cheers,
cookie.

> Have a look at these sections, you'ld get what you're searching
> Do you read the previous chapter i pointed you to?
> It tells you what and how to instantiate.
>
> Regards
> Michel Cadot
>
>
Received on Mon Feb 09 2004 - 03:30:57 CST