Re: Tuning data transfer between Oracle databases.

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

Use the copy comand in the SQL*plus instead of insert into so that you don't have to worry about the rollabck segment size.

set the arraysize and copycommit before executing the copy command.

Vijay Darekar Received on Mon Oct 06 1997 - 00:00:00 CDT