Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

How to move csv file into oracle database without creating table firstly using sql developer rather than sql loader?

share|improve this question

migrated from stackoverflow.com Oct 9 '13 at 3:39

This question came from our site for professional and enthusiast programmers.

You're likely to need to give more information, but even so, this is not a question for SO. Try Database Administrators –  Mike W Oct 9 '13 at 0:09
You need to give more information about what you're trying yo achieve. Specifically, what do you mean by "without creating table firstly"? We can't "move" a file into the database. We can load the data from a CSV file into a table. So you need a table. Do you mean you don't want to create an external table to load the CSV? –  APC Oct 9 '13 at 4:31

2 Answers 2

Check How to Import from Excel to a New Oracle Table with SQL Developer and How to Import from Excel to Oracle with SQL Developer, they talk about loading xls files into a db, but the process is the same for CSV. It will let you import into an existing table or let you create a table as part of the import process.

share|improve this answer
I hope those links survive forever. –  Colin 't Hart Jun 7 '14 at 16:07

I don't use sql developer before,you may try:sqlldr,this tool can meet your requirements

share|improve this answer
You should add more detail to your answer - perhaps how the tool works, or why it is well suited to the problem. As is, this answer is likely to be deleted since it doesn't contain any information except a product recommendation. –  Max Vernon Oct 10 '13 at 20:00
And the whole point is that SQL Developer has a wizard for driving SQL*Loader. –  Colin 't Hart Jun 7 '14 at 16:06

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.