Oracle Database Discussions

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 data from tsv (tab separated values) file

781461Jun 25 2010

I have a large tab separated values file that I want to import into an oracle table so I can a) run queries on this data and b) split into smaller and more manageable files.

I'm very new to Oracle. I have installed 10g XE and sql_developer.

This tsv file has 3,684,011 rows. Maybe it could be imported into an Access DB then into Oracle, but that seems like extra work??

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 23 2010

Added on Jun 25 2010

#database-and-application-migrations

0 comments

1,714 views