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.
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:
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:
Suggested option to export DDL and Data is IMPDP
.
Cheers!!