0

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.

Improve this question
1
  • If that answer solved your question then please accept it, so that your question is marked as resolved. Commented Aug 12, 2019 at 10:13

1 Answer 1

Reset to default
3

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!!

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

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.