-
Best Way to unload/Load Data
Hi,
I need to extract data(huge amount of data) with some filters and then i need to load it to a different database.Can any one tell me which is the best/reliable/fast way to accomplish this.
-
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
Amar
"There is a difference between knowing the path and walking the path."
-
I would think export/import, is sqlloader any better/faster/more reliable?
MH
I remember when this place was cool.
-
-
Originally posted by Mr.Hanky
I would think export/import, is sqlloader any better/faster/more reliable?
MH
Both the Utilities have same purpose but their Data source are Different. SQL*loader extracts from Text file whereas Import can load only from Oracle Export generated DMP file. So I dont think we can compare them directly.
-- Dilip
-
SQL*LOADER is def. faster if you use direct load option. Import is conventional. I don't think it is faster method when compared to SQL*LOADER.
Raghu
-
For one-off data transfers, especially those requiring a filtered set of data, I'm a big fan of the SQL*Plus copy command because ...
i) the syntax is very simple to remember.
ii) it's generally a single stage process
iii) no mucking about at the O/S level, with temporary file storage requirements, parfiles etc.
iv) you can implement physical row ordering very simply if required.
v) i've found it to be faster in many cases even than direct export/import
Plenty of contraversial stuff there, I hope.
-
You can also set up commits at different intervals if you like.
I prepared a document for our developers to use SQL Copy, most of it was pulled from SQL* The Definitive Guide on O'Reilly.
MH
I remember when this place was cool.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|