My Oracle Support Banner

How to Move a SQL Tuning Set from One Database to Another (Doc ID 751068.1)

Last updated on OCTOBER 03, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Goal

This document explains how to transfer the SQL Tuning Set (STS) from one database to another and demonstrates some issues regarding the transfer of STS and their resolution.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
 Actions to Perform the Transfer:
 Preliminary Setup:
 Actions to Perform the Transfer: Detail
 Create/load STS test_set owned by SYS
 Create stgtab sqlset_tab table in TEST schema:
 Pack test_set into the stgtab
 Transfer the table containing the SQL SET (SQLSET_TAB) table to the TEST system
 Export/import into test system, connect as scott
 Attempt to unpack an STS named 'testtarget_test_set'
 MAPPING
 UNPACK THE SQLSET_TAB TABLE IN THE TEST SYSTEM
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.