Re: streams capture specify SCN without dbms_cature_adm.build

From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Fri, 8 Apr 2011 12:32:07 -0400
Message-ID: <BANLkTi=KcxM7VazpvB-6P4LDLBMAft2EFw_at_mail.gmail.com>

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

Received on Fri Apr 08 2011 - 11:32:07 CDT