RE: streams capture specify SCN without dbms_cature_adm.build
- From: Upendra N <nupendra@xxxxxxxxxxx>
- To: <afatkulin@xxxxxxxxx>
- Date: Fri, 8 Apr 2011 12:43:54 -0400
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@xxxxxxxxx
> To: nupendra@xxxxxxxxxxx
> CC: oracle-l@xxxxxxxxxxxxx
>
> 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@xxxxxxxxxxx> 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
Other related posts:
