streams capture specify SCN without dbms_cature_adm.build
From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Thu, 7 Apr 2011 16:22:21 +0700
Message-ID: <BANLkTin-UboU_-kCXd1P2XC1T0rrMXYV_g_at_mail.gmail.com>
dear lists,
Date: Thu, 7 Apr 2011 16:22:21 +0700
Message-ID: <BANLkTin-UboU_-kCXd1P2XC1T0rrMXYV_g_at_mail.gmail.com>
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
Received on Thu Apr 07 2011 - 04:22:21 CDT