RE: streams capture specify SCN without dbms_cature_adm.build

Sorry for not being clear. I was referring to explicitly running "dbms_capture_adm.build" at the time of gathering the initiation SCN.

-Upendra

> Date: Fri, 8 Apr 2011 12:32:07 -0400
> Subject: Re: streams capture specify SCN without dbms_cature_adm.build
> From: afatkulin_at_gmail.com
> To: nupendra_at_hotmail.com
> CC: oracle-l_at_freelists.org
>
> And what exactly in this Note leads you to believe you can do it without build?
>
> In the steps described in this note the build will be implicitly done
> when capture process is created.
>
> It is clearly documented that you must do the build in Steams documentation:
>
> "When the new capture process is started for the first time, it
> creates a new LogMiner data dictionary using the data dictionary
> information in the redo log. If the BUILD procedure has not been run
> at least once on the source database, then an error is raised."
>
> http://download.oracle.com/docs/cd/E18283_01/appdev.112/e16760/d_cap_a.htm#BGBFHAIJ
>
> On Fri, Apr 8, 2011 at 12:26 PM, Upendra N <nupendra_at_hotmail.com> wrote:
> > See below a note from Metalink, which doesn't use build.
> > How To Setup One-Way SCHEMA Level Streams Replication (Doc ID 301431.1)
> >
> > Worst case you can still setup Streams without build.
> --
> Alex Fatkulin,
> http://afatkulin.blogspot.com
> http://www.linkedin.com/in/alexfatkulin
                                               

--
http://www.freelists.org/webpage/oracle-l