How to export Oracle DB data using SQL Developer? I need all the data, tables, constraints, structure, etc.
In SQL Developer, from the top menu, choose Tools> Export Data. This launches the data export wizard. It is pretty simple.
The OTN website has a tutorial. Find it here .
In version 3, they changed " export " to " unload ". It still functions more or less the same.
If at any moment you need to export only one set of results, just right-click "by data" (any column of any row), there you will find the export option. The wizard exports a complete set of results no matter what you select.
To export data, you need to right-click on your results and select data export, after which you will be asked to specify a specific file format, for example insert , loader or text , etc. After selecting this view your directory and select the export destination.
insert
loader
text