Importing a SQL Tuning Set

Before a SQL Tuning Set can be imported, you must first export a SQL Tuning Set from another system and transport it to your current system. For more information, see "Exporting a SQL Tuning Set".

To import a SQL Tuning Set: 

1. On the Database Performance page, under Additional Monitoring Links, click SQL Tuning Sets.

   The SQL Tuning Sets page appears.

2. Click Import.

   The Import SQL Tuning Set page appears.

3. In Directory Object, select the directory containing the file to be imported.

   The directory should contain the export file that was transported to your current system. For example, if the file resides in the Data Pump directory, then select DATA_PUMP_DIR. The Directory Name field refreshes automatically to indicate the selected directory.

4. In the Import File field, enter the name of the dump file that will be imported.

5. In the Log File field, enter a name for the log file for the import operation.

6. To replace an existing SQL Tuning Set with the one that you are importing, select Replace the existing SQL tuning set if one exists.

7. Select a tablespace to temporarily store the data for the import operation.

   By default, SYSAUX is used.

8. Under Job Parameters, in the Job Name field, enter a name for the job.

   Alternatively, you can accept the name generated by the system.

9. Under Schedule, do one of the following:

   • Select Immediately to run the job immediately after it has been submitted.

   • Select Later to run the job at a later time as specified by selecting or entering values in the Time Zone, Date, and Time fields.

10. Click OK.

    The SQL Tuning Sets page appears.

    A confirmation message is displayed to indicate that the job was successfully created. If the job is scheduled to run immediately, then the imported SQL Tuning Set will be shown on this page. You may need to refresh to see the SQL Tuning Set.