Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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?
Although there are better ways to do what you want to do ( Replication comes to mind), you can use the EXP utility to export just 1 schema ( User) and the other side can then IMP the data into the schema there.. Received on Fri Oct 28 2005 - 08:37:21 CDT