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
1  
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
add comment

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

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

2 Answers

Check http://www.thatjeffsmith.com/archive/2012/08/how-to-import-from-excel-to-a-new-oracle-table-with-sql-developer/ and http://www.thatjeffsmith.com/archive/2012/04/how-to-import-from-excel-to-oracle-with-sql-developer/, it talks about loading xls file into db, but process is same for CSV. It will let you import into existing table or let you create a table as part of the import process.

share|improve this answer
add comment

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
add comment

Your Answer

 
discard

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