Tutorial: Creating an Installation Script File for the Synonym and View

This tutorial shows how to use the SQL Developer tool Database Export to create an installation script file for the synonym and view of the sample application.

To create an installation script file for the synonym and view:

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_other.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 Views and Synonyms.

   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, select the value VIEW.

   3. Click Go.

      A list of the views in schema HR appears.

   4. Select HR.EMP_LOCATIONS.

   5. Click >.

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

   6. In the drop-down menu with the value VIEW, select the value SYNONYM.

   7. Click Go.

      A list of the synonyms in schema HR appears.

   8. Select HR.EMP.

   9. Click >.

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

   10. (Optional) In the drop-down menu with the value SYNONYM, select the value All.

       HR.EMP_LOCATIONS and HR.EMP show.

   11. 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_other.sql.