Re: Best way to replicate schema data to another database?

zenshade_at_gmail.com wrote:
> We need to essentially export the data from a single schema in our
> Oracle8i database and send it securely over a network to an Oracle9i
> database, in such a format that it can be easily imported. This needs
> to be done several times a day to keep the remote DB fairly up to date.
> On the source DB we have several other schemas that cannot be part of
> the export for security reasons, so we can't just create a remote
> backup using transaction log files, unless it is possible to filter
> those by schema.
>
> Right now, we're looking at trying to use Log Miner to do this, but
> please bonk me over the head if this is horribly naive. Is there a
> better, more efficient way?

Well you ask the best way to replicate data.

I think oracle replication is probably what you want to look at.

I haven't look much at the 10g new version of it ( think they stick it with the new name streams ) ... but you should check out the documentation for the version that you are running. Received on Thu Oct 27 2005 - 19:25:02 CDT