Tutorial: Creating an Installation Script File for the Package

This tutorial shows how to use the SQL Developer tool Database Export to create an installation script file for the package (specification and body) of the sample application.

To create an installation script file for the package:

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_package.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 Package Spec and Package Body.

   2. Click Next.

   The Specify Objects window appears.

6. In the Specify Objects window:

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

   2. In the drop-down menu with the value All, accept that value.

   3. Click Go.

      A list of the packages and package bodies in schema HR appears.

   4. If the only items listed are the package HR.EMP_EVAL and the package body HR.EMP_EVAL, click >>; otherwise, select those two items from the list and click >.

      The package HR.EMP_EVAL and the package body HR.EMP_EVAL move 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 installation script file that you specified in step 4.