Use data pump.
I believe that SQL Developer has a menu item somewhere to run it, or you can run from the command line or from the PL/SQL API.
Which version of sqldeveloper?
If you're using the later version of SQL Developer you can use the data modeller to generate the DDL for all schemas / objects in order (just pull down the latest 4.x release).
SQLDeveloper -> File -> Data Modeller -> Export -> DDL file
Then choose your schema, objects, dependencies. This will generate tables, indexes then constraints & also your packages. Handy for exporting to a model too. I'd probably go with Johns recommendation though, datapump is quicker & cleaner for a full DB dump.
thanks guys for the answers!
@John Stegeman: I found the option to export data pump for SQL Developer. I post a screenshot.
A question, but for this procedure and exports, you are not considered the views and triggers? What if I want to extract these items?
I have a problem though, at the end of the wizard, when I click the button end, this exception is raised
ORA-31626: job does not exist.
I do not understand.
@jgarry: the version of sql developer is 22.214.171.124.84
@cobert: I'm trying SQLDeveloper -> File -> Data Modeller -> Export -> DDL files, but I have to follow some tutorials, because I do not know to complete.
Absolutely, whichever is cleanest & gives the best results
More detailed instructions below, first you need to pull in the definition you're looking for:
File -> Data Modeller -> Import Data Dictionary -> Connect to your Database
-> choose the schema(s) that you want & select all objects
-> click finish (this will then generate your dictionary model & your design)
You can then export your definitions to a DDL file
File -> Data Modeller -> Export Data (you will be presented with your connection details)
-> choose generate
-> then in the create selection, check that it says "regular DDL" and click OK.
This should then generate your DDL file in order.
Note that thatjeffsmith.com is very useful.