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

On 27 Oct 2005 15:59:15 -0700, 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.

How big are the schemas?
What's the purpose of replication?
If small 'downtime' is OK use
exp for ease of export
scp for secure transfer
imp for ease of import

or explore what others have advised.

-a

.......
We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4 remove NSPAM to email Received on Fri Oct 28 2005 - 10:44:22 CDT