Re: streams capture specify SCN without dbms_cature_adm.build
- From: Ujang Jaenudin <ujang.jaenudin@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 8 Apr 2011 22:18:48 +0700
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@xxxxxxxxx> 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@xxxxxxxxx>
> 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
>> --
>> //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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
