Re: streams capture specify SCN without dbms_cature_adm.build
- From: Alex Fatkulin <afatkulin@xxxxxxxxx>
- To: ujang.jaenudin@xxxxxxxxx
- Date: Thu, 7 Apr 2011 13:13:17 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
