How to export Oracle DB data using SQL Developer? I need all data, tables, constraints, structure and so on.
This question is related to
sql
oracle
oracle-sqldeveloper
If, at some point, you only need to export a single result set, just right click "on the data" (any column of any row) there you will find an export option. The wizard exports the complete result set regardless of what you selected
In version 3, they changed "export" to "unload". It still functions more or less the same.
To export data you need to right click on your results and select export data, after which you will be asked for a specific file format such as insert
, loader
, or text
etc. After selecting this browse your directory and select the export destination.
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.
Source: Stackoverflow.com