How to Export Data using SQL Developer
Updated: Nov 2009 for SQL Developer 2.1
After completing this How-To, you should be able to understand:
Oracle SQL Developer provides utilities to export both the definitions of the objects in a schema and the data stored in those objects. In this How-To we start by exporting the data and then move onto exporting object definitions.
SQL Developer provides the ability to export user data to a variety of formats: CSV, XML, LOADER, TEXT, INSERT, HTML and XLS.
Expand the Connections Navigator and the Tables node.
Click on DEPARTMENTS.
Select the Data tab.
Select insert from the Export Data context menu. This will produce a file of insert statements.
You can also fine tune what is exported by selecting the columns and adding a where clause to reduce the number of records returned. In this example, we'll take the default of all the records and columns.
SQL Developer provides the ability to export some or all of your object definitions to script files. You can use these as a backup of the object definitions or run them in another schema. In this exercise, you export all the object definitions and the data for the Departments table.
Click Go. The list now displays tables that start with "D".