How to export large amount of data using sql devel

Question

I want to upload some data from UAT DB to DEV DB. When I try to do this from Export function in SQL Developer, I got an error File C:\Users\xxx\export.sql was not opened because it exceeds the maximum automatic open size

How can I copy the UAT data to DEV ?

ORACLE Version 12C
SQL Developer Version 4.0.0.13

Answer 1

There is a trick to copy large chunk of data (from SQL developer) into excel sheet.

steps to be followed : Right click ---> export data ----> select format type as 'Text' ---> select type as "Clipboard" ----> open an excel sheet and try to paste keeping the below in mind :)

Then paste the data NOTE : **Do Not paste the data on the first cell of the excel. Ctrl+v in any of the columns **

This will work.

Thanks

Answer 2

You can use spool the query and save the results as CSV or XLSX files for larger results. For example:

spool "D:\Temp\Report.csv"
SELECT /*csv*/ select id,name,age from EMP;
spool off;