Re: streams capture specify SCN without dbms_cature_adm.build

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Fri, 8 Apr 2011 22:18:48 +0700
Message-ID: <BANLkTikgkCh31Cuai_MW1d3-dujt9EmSwQ_at_mail.gmail.com>



according to bpolarsk, theoretically it is possible... http://forums.oracle.com/forums/thread.jspa?threadID=966766&tstart=225

may be someone here had proved the theory?

On Fri, Apr 8, 2011 at 12:13 AM, Alex Fatkulin <afatkulin_at_gmail.com> wrote:
> The build is required for data dictionary build to be dumped into the
> redo stream which can then be used to populated the MVDD.
>
> If you didn't do the dictionary build then you won't be able to start
> your capture process (it will be in "waiting for dictionary redo"
> forever).
>
> On Thu, Apr 7, 2011 at 5:22 AM, Ujang Jaenudin <ujang.jaenudin_at_gmail.com> wrote:
>> dear lists,
>>
>> we had done impdp, and didn't do dbms_capture_adm.build before expdp.
>> but we noted the scn before expdp and specify that SCN during expdp.
>>
>> so my question, can we set SCN for the capture process
>> by using dbms_logmnr.start_logmnr(STARTSCN...
>> ...   OPTIONS=> DBMS_LOGMNR_D.STORE_IN_REDO_LOGS);
>>
>> we are in 10.2.0.1
>>
>>
>> --
>> thanks and regards
>> ujang jaenudin
>> jakarta - indonesia
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
>
> --
> Alex Fatkulin,
> http://afatkulin.blogspot.com
> http://www.linkedin.com/in/alexfatkulin
>

-- 
thanks and regards
ujang jaenudin
jakarta - indonesia
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 08 2011 - 10:18:48 CDT

Original text of this message