Re: Moving a lot of rows against a remote database using db-link

From: Michael Oswald <michael.oswald_at_siemens.at>
Date: Mon, 20 Nov 2000 18:36:25 +0100
Message-ID: <3A196119.50C16D85@siemens.at>

Antonio Sant schrieb:

> Hi there!
>
>
> Insert into far_table_at_far_db
> select * from local_table
>
> Is this effective? Can we do better?
>

I don't know, if it is effective in Oracle Version 7, but in 8.1.5 Oracle performs a direct-load-insert on this statement and this is far more effective than normal inserts. This way I had to copy tables with more than 5 000 000 entries and it worked quite well.

Mike Received on Mon Nov 20 2000 - 11:36:25 CST

This message: [ Message body ]
Next message: James Williams: "Best way to reorganize a schema"
Previous message: Antonio Sant: "Moving a lot of rows against a remote database using db-link"
In reply to: Antonio Sant: "Moving a lot of rows against a remote database using db-link"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US