CODEWITHSUNDEEP
sqldatabaseoracle-databaseoracle-sqldeveloper
Xultron
Xultron

Reputation: 33

How to export only data from a database in SQL DEVELOPER

I want to export my data base in parts, like the tables, the data, etc. So I would like to know how i can export only the data from a date base in SQL developer preferebly in the application tools.

Upvotes: 0

Views: 75

Answers (1)

Popeye
Popeye

Reputation: 35900

In SQL Developer you can do it from Tools --> Database export

You need to select the connection and then select the following options according to the requirement:

  • Only DDL, select "Export DDL" and unselect "Export Data".
  • Only data, select "Export Data" and unselect "Export DDL".

Then in Next screens, You will be able to find some configurations for export and then finally you can do export in .sql file.

Screenshot:

enter image description here

Suggested option to export DDL and Data is IMPDP.

Cheers!!

Upvotes: 3

Related Questions