Tutorial: Creating an Installation Script File for the Data

This tutorial shows how to use the SQL Developer tool Database Export to create an installation script file for the data of the sample application. If you followed the instructions in this document, you added data only to the table PERFORMANCE_PARTS.

To create an installation script file for the data:

1. If you have not done so, create the directory C:\my_exports.

2. In the SQL Developer window, click the menu Tools.

   A drop-down menu appears.

3. From drop-down menu, select Database Export.

   The Source/Destination window opens.

4. In the Source/Destination window:

   1. In the File field, type: C:\my_exports\2day_data.sql.

   2. From the Connections drop-down menu, select hr_conn.

   3. Accept the default DDL Options, Terminator and Pretty Print.

   4. Click Next.

   The Types to Export window appears.

5. In the Types to Export window:

   1. Deselect all check boxes except Data.

   2. Click Next.

   The Specify Data window appears.

6. In the Specify Data window:

   1. In the drop-down menu with the value HR, accept that value.

   2. Click Go.

      A list of the tables in schema HR appears.

   3. Select HR.PERFORMANCE_PARTS.

   4. Click >.

      HR.PERFORMANCE_PARTS moves from the original column to the other column.

   5. Click Next.

   The Export Summary window appears.

7. In the Export Summary window, click Finish.

   The Exporting window opens, showing that exporting is occurring. When exporting is complete, the Exporting window closes, and the SQL Worksheet shows the contents of the file C:\my_exports\2day_data.sql.