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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


migration rejected from Aug 3 '15 at 9:21

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Paul White, Colin 't Hart, Kin, RolandoMySQLDBA, dezso Aug 3 '15 at 9:21

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Colin 't Hart, Kin, RolandoMySQLDBA, dezso
If this question can be reworded to fit the rules in the help center, please edit the question.

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

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.

I hope those links survive forever. – Colin 't Hart Jun 7 '14 at 16:07