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.

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

Quote:

---

Originally posted by Mr.Hanky
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.

Faster - yes, direct load is the fastest.

Reliable - yes, atleast more than exp/imp :)

Quote:

---

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.

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