How to Export Database in Oracle SQL Developer

Here are the steps to for exporting the data in Oracle SQL Developer. These are very simple steps which can be performed to extract any of the database objects.

To export a database in Oracle SQL Developer, follow these steps:

Method 1: Export Using Data Pump

1. Open Oracle SQL Developer and connect to your database.
2. Open DBA Panel:
   • Go to View → DBA.
   • Right-click your connection and select Add Connection.
   • Expand the connection and navigate to Data Pump → Export Jobs.
3. Create an Export Job:
   • Right-click Export Jobs and select New Export Job.
   • Choose Full, Schema, Table, or Tablespace Export.
   • Configure the directory, file name, and options (compression, parallelism, etc.).
   • Click Start to export.

Method 2: Export Schema/Tables Using SQL Developer GUI

1. Connect to the database in SQL Developer.
2. Go to Tools → Database Export.
3. Select Export Options:
   • Choose whether to export a full schema, specific tables, or objects.
   • Set output format (SQL script, CSV, etc.).
4. Choose Save Location:
   • Specify file name and directory for the exported file.
5. Click Finish to generate the export file.

Method 3: Export Data Only (CSV, Excel, etc.)

1. Right-click a table and select Export.
2. Choose the format (CSV, Excel, JSON, XML, etc.).
3. Specify the file location.
4. Click Next → Finish.

These are some of the methods which can be leveraged for the database export. Try and test it out with these methods and choose the best that suits you.