My Oracle Support Banner

How to Transport a SQL Tuning Set (STS) (Doc ID 456019.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
Checked for Relevance 16-MAY-13

Goal

The Purpose of this Document is to Show the Steps needed to Transport a SQL Tuning Set (STS) from One Database server to another Database Server.

This is illustrated by moving information from 10g to 11g, but this could equally apply to information from 11g to 11g or any later version.

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
 Create the Staging Table ON THE SOURCE SYSTEM ( IN this case 10.2 )
 Populate the table TEST using DBMS_SQLTUNE.PACK_STGTAB_SQLSET THE SOURCE SYSTEM (IN this case 10.2 )
 Export the table table test on THE SOURCE SYSTEM ( IN this case 10.2.)
 Move the Export file to the Destination Server
 Import on the Destination system ( IN this CASE it was 11.2)
 Unpack the table using DBMS_SQLTUNE.UNPACK_STGTAB_SQLSET on the Destination system ( IN this CASE it was 11.2)

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