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