How to export multiple tables in oracle into multiple .csv files in Oracle SQL developer

Question

I am trying to export multiple tables to individual .csv files (approximately 70 tables need to be exported) in oracle SQL Developer. As of right now, I am running through this process

Run Query

SELECT * FROM TABLE;

From the result window, click "Export Query Results", choosing the encoding and delimiter and saving it as a .csv

This is a lengthy process, and takes around a minute per table (lots of information!), I can't help but think there has to be an easier, more efficient way of doing this. I just can't find any information.

user_1156452 · Answer

Tools - Database Export

Pick your file format (csv) and directory.

I have Excel shown in the picture, but there's a dozen formats to choose from, including delimited and CSV. If you want European CSV (;), pick delimited and change the delimiter to ;

Then pick your 70 tables.

user_5341247 · Answer

I think the best solution for mass table export is not to use the embedded SQL Developper export tool, but use the SPOOL SQL option.

you can check here how to generate SPOOL files: How do I spool to a CSV formatted file using SQLPLUS?

How to export multiple tables in oracle into multiple .csv files in Oracle SQL developer

2 Answers