60

How to export Oracle DB data using SQL Developer? I need all data, tables, constraints, structure and so on.

Improve this question

4 Answers 4

Reset to default
58

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Newer tutorial docs.oracle.com/cd/E17781_01/server.112/e18804/…
16

In version 3, they changed "export" to "unload". It still functions more or less the same.

Improve this answer

Comments

13

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

Improve this answer

2 Comments

So it doesn't really matter what I select - I always get the whole table? Sounds pretty logical ...
Figured out that the whole table is always exported, so if you want to only export a subset of your table, just specify via the filter-option and then use the export-function. You'll can then export only what you need.
4

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.

Improve this answer

1 Comment

This was more helpful than the accepted answer .. +1 ... I can't find the Tools > Data Export option in my free download of Oracle SQL Developer. I might not have installed it correctly.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.