Best Way to unload/Load Data
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Best Way to unload/Load Data

  1. #1
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159

    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.
    Share on Google+

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    "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
    Share on Google+

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    SQLLOADER
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Share on Google+

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    I would think export/import, is sqlloader any better/faster/more reliable?

    MH
    I remember when this place was cool.
    Share on Google+

  5. #5
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Share on Google+

  6. #6
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    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
    Share on Google+

  7. #7
    Join Date
    Aug 2001
    Posts
    267
    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
    Share on Google+

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE
    Share on Google+

  9. #9
    Join Date
    Jan 2001
    Posts
    3,131
    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.
    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width