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.
Printable View
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.
This may help http://www.dbasupport.com/forums/sho...threadid=34911
SQLLOADER
I would think export/import, is sqlloader any better/faster/more reliable?
MH
Better - Have better control on data selectivity ie better control on what i spool.Quote:
Originally posted by Mr.Hanky
I would think export/import, is sqlloader any better/faster/more reliable?
MH
Faster - yes, direct load is the fastest.
Reliable - yes, atleast more than exp/imp :)
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.Quote:
Originally posted by Mr.Hanky
I would think export/import, is sqlloader any better/faster/more reliable?
MH
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.
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