Menu
How to export Oracle DB data using SQL Developer? I need all data, tables, constraints, structure and so on.
723
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 :) This will work.
Select Miscellaneous > File Export > General or Configuration > External > Export Files to access the Export File List screen. Select the export from the list and select the Edit button to access the Export File Details screen. Select the Export Columns button. The Export Column Details screen appears.
In SQL Developer, from the top menu choose Tools > Data Export. This launches the Data Export wizard. It's pretty straightforward from there.
There is a tutorial on the OTN site. Find it here.
159
In version 3, they changed "export" to "unload". It still functions more or less the same.
37
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
