This discussion is archived
6 Replies Latest reply: Dec 10, 2012 4:50 PM by SamFisher RSS

Data loading options

SamFisher Explorer
Currently Being Moderated
Hello All,

Are there any other options other than SQL*LDR & External tables to load external data in ORCL?

Thanks,
Shank.
  • 1. Re: Data loading options
    908002 Expert
    Currently Being Moderated
    yes, you can use options in editors like toad / sql developer
  • 2. Re: Data loading options
    SamFisher Explorer
    Currently Being Moderated
    Toad again uses SQL*LDR. Is there other utility other than the 2 options that I have mentioned?
  • 3. Re: Data loading options
    Justin Cave Oracle ACE
    Currently Being Moderated
    What is the problem with SQL*Loader and/or external tables that you would hope some other tool would provide? There are any number of ELT tools on the market, for example, that can load data from a flat file. You can use database links to load data from other databases (Oracle and non-Oracle). You can use the export and import utilities (preferrably the DataPump versions) to move data between Oracle databases. Without knowing what problem you are trying to solve, though, it's impossible to guess whether this is helpful to you or not.

    Justin
  • 4. Re: Data loading options
    SamFisher Explorer
    Currently Being Moderated
    Apologize for not providing the details.
    I was just curious to know if there are other options.
  • 5. Re: Data loading options
    BluShadow Guru Moderator
    Currently Being Moderated
    SamFisher wrote:
    Hello All,

    Are there any other options other than SQL*LDR & External tables to load external data in ORCL?

    Thanks,
    Shank.
    There are many ways to read data.

    SQL*Loader is an external command line utility
    External Tables are an internal mechanism that using the same 'engine' as the SQL*Loader utility, in order to be able to read data as if it's on a table already (hence it can be used through SQL).
    You could also use the UTL_FILE package to read files line-wise or byte-wise as a low level mechanism.
    Also, methods such as BFILE reading as demonstrated... ( goes off to find an example ).... here:

    {message:id=9732075}

    There are also other built in packages that contain procedures/functions that offer some form of file reading and writing.
    And you can also create your own using Java in the database.

    So, take your pick... lots to choose from... and it all depends what you want to do.
  • 6. Re: Data loading options
    SamFisher Explorer
    Currently Being Moderated
    Thank You all.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points