"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<3faa9e15$0$9224$afc38c87_at_news.optusnet.com.au>...
> "Joe" <emanonii_at_yahoo.com> wrote in message
> news:63bb2d27.0311060517.22595651_at_posting.google.com...
> > Because the they want minimal downtime and the initial load involves
> > either shipping a tape across the country or FTPing 50gb. In either
> > case, there will be a number of hours where no changes could be made
> > to the source system. Is there a way where after the export/import is
> > done that any changes could be rolled to the new box?
>
>
> Yes: Log Miner (your existing production system would need to be in
> archivelog mode). You can manually extract the SQL Statements from a known
> time from the logs, and produce SQL scripts to run against your new
> database.
>
> But it's problematicas to whether you'd trap every possible change in this
> way... it's wide open to user error.
>
> That's why I'd agree with Richard: investigate alternatives such as Streams,
> replication, or third party products.
>
> Regards
> HJR
Hello everyone,
Thanks for your responses. I thought about log miner, but was hoping
there was an easier way. I'll check into the alternatives presented.
Once again, thanks.
Received on Fri Nov 07 2003 - 06:29:08 CST
