Re: Tuning data transfer between Oracle databases.

From: Someone <answers_at_erols.com.tyfns>
Date: 1997/10/05
Message-ID: <34372A1C.AFC66EAD@erols.com.tyfns>#1/1

This is a multi-part message in MIME format.

--------------EC2928AE51B34CE91DD19E9A
Content-Type: text/plain; charset=us-ascii
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Transfer-Encoding: 7bit

Have you considered doing an export, FTP, and import? Not knowing the volume or other specifics, you have to evaluate the suggestion in the context of your environment.

RastM wrote:

> I've got three Oracle databases. On one machine I've got a V6.0.37
> and a
> V7.0.16 database. On another machine I've got a V7.3.2 database. I'm
>
> passing data from the V6.0.37 database to the V7.3.2 database via a
> SQL
> script executed by the V7.0.16 database:
>
> INSERT INTO table_at_link_to_V73_database
> SELECT * from table_at_link_to_V6_database
> .
> .
> .
>
> The link to the V6.0.37 database is SQL*Net Pipes and the link to the
> V7.3.2 database is SQL*Net TCP/IP.
>
> What kinds of tuning can I do to make sure this is working as fast as
> possible (rollback segment sizes, SQL*Net parameters, init.ora
> parameters,
> etc.)? How much do I need to worry about the V7.0.16 database? All
> I'm
> using it for is to execute the SQL script.
>
> Any advice is appreciated.
>
> --
> tkupp at pacifier dot com

--------------EC2928AE51B34CE91DD19E9A
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Someone
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Someone
n:              ;Someone
email;internet: answers_at_erols.com.tyfns
title:          Important
note:           Remove tyfns from my email address to reply.  TYFNS stands for "Thank you for not spamming."

x-mozilla-cpt: ;0
x-mozilla-html: FALSE
end: vcard

--------------EC2928AE51B34CE91DD19E9A-- Received on Sun Oct 05 1997 - 00:00:00 CDT