Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import/elaborate big text file: the best way to do this?

2757628Sep 24 2014 — edited Sep 25 2014

Hi all,

I'm new on PL/SQL (I had always worked with SQLServer and MySql) and I need help to understand the best way to import a big text file to DB in order to elaborate the contained informations.

The files that I have to manage contain positional informations and could be composed by millions of rows.

I have to:

  1. Import the file
  2. Translate the informations in table format
  3. Elaborate the data

I think to use one of the following options for the import step:

  • UTL_FILE (row by row) this could be useful to insert data directly in table structure
  • Use a Data Integrator software like Talend
  • Insert file content into a BLOB field and, after this, bring data to destination table

Which is the best way to do this? Are there other best alternatives?

Thanks

Fabio
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2014
Added on Sep 24 2014
8 comments
2,172 views