Which method: dblink or import/export?

From: Paschal Mushubi <bs260_at_FreeNet.Carleton.CA>
Date: 23 Apr 1999 01:35:31 GMT
Message-ID: <7foip3$7mv@freenet-news.carleton.ca>

My task:
Populating a table in a local Oracle database with data from a remote Oracle database:
Which of these two methods is more efficient for transferring large amounts of data?

Using database link:
PL/SQL procedure opens cursor and selects data from a remote database then iserts them into a local database

Import/Export:
Dump data from a remote table into a dat file then ftp it to local machine and use sqlloader to insert the data.

Other options?
Suggestions, please.

Regards.

paschal. Received on Thu Apr 22 1999 - 20:35:31 CDT

This message: [ Message body ]
Next message: Shiv: "Des 2.11 installation win/98. Error : " The oracle80.exe file is linked to missing export NZ80.dll : nztpfvec ". --> Help needed."
Previous message: Marc Durand: "Migration from V7 to V8 on HP-UX 10.20"
Next in thread: Ron Reidy: "Re: Which method: dblink or import/export?"
Reply: Ron Reidy: "Re: Which method: dblink or import/export?"
Reply: Wicksey: "Re: Which method: dblink or import/export?"
Reply: Patrick Suppes: "Re: Which method: dblink or import/export?"
Reply: Jeffery G. Wong: "Re: Which method: dblink or import/export?"

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