Re: streams capture specify SCN without dbms_cature_adm.build

  • From: Alex Fatkulin <afatkulin@xxxxxxxxx>
  • To: Upendra N <nupendra@xxxxxxxxxxx>
  • Date: Fri, 8 Apr 2011 12:32:07 -0400

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: