Have you considered a stand-by database instead? You can open it in read only mode, then update it at a time that is convenient for you.
And the product is called LogMiner... a Minor is a child, a Miner is an old guy with a long beard that smells to high heaven and sits in front of his deep gold mine with a shotgun ready to shoot anyone thats going to try to steal some of that there gold. RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -----Original Message----- Sent: Tuesday, January 21, 2003 2:56 PM To: Multiple recipients of list ORACLE-L I am trying to find out more on using LogMinor to create a reportable database. I plan to duplicate production schema on different server and use LogMinor to apply only some changes to reportable database. Also I am planning to create triggers that will sort new data from archive logs to denormalized tables on reportable database. Has anybody done similar? I found bits and pieces but no real examples how to extract only the data that I need. I am running 8.1.6 on Solaris. Thank you. Sergei. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sergei INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
