SQL Developer 1.5.5 Extract to to CSV
Date: Fri, 6 Mar 2015 22:06:35 -0000
Message-ID: <mdd8dn$2cda$1_at_adenine.netfront.net>
I desperately need to extract all tables in an Oracle Database and dump them into seperate CSV files.
Sorry, but most of my experience to date (which is not enough in my view) has been MS-SQL related so I am not familiar with the oracle tools. I have Googles and found about 5 different ways to try and achieve the same, but they have all had slight hickups.
The only way I have managed to get this done is to use SQL Developer 1.5.5. using the following steps
- Ran a script to show me all tables containing data
- Find the first table containing data, click on the data view
- Right click anywhere on the data, select export and then csv.
- Ensure the correct output directory is specified (handily the file name take defaults to the table name)
- Click Apply and wat for the export to finish
- Select the next table, export and apply and continue repeating this until all are exported.
As you can Imagine this can take some time... Took me two hours today to export 183 tables like this.
I was wondering whether it is not possible to script this. I have tried doing it via sqlplus, but found the output limited to 5000records and some problems with formating header rows repeating. Therefore Ideally I would prefer to simply use Script in SQL Developer that can place the output to CSV. I would really appreciate step by step instructions for the uninformed as I am not too familiar with the sql developer toolset.
Regards
C
- news://freenews.netfront.net/ - complaints: news_at_netfront.net ---