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?
Received on Thu Oct 27 2005 - 17:59:15 CDT
