Re: oracle streams error

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 7 Feb 2004 15:48:26 +0100
Message-ID: <4024fa34$0$28161$626a14ce@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 ...

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 Sat Feb 07 2004 - 08:48:26 CST