Solaris Systems Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

1. Creating a staging table to store the SQL Profiles:

  exec DBMS_SQLTUNE.CREATE_STGTAB_SQLPROF (table_name=>'SQL_PROFILES_TT',schema_name=>'SCOTT');

2. Select SQL profiles names available in the source database.

  SELECT name FROM dba_sql_profiles; 

3. Packing the SQL Profiles to the staging table

  EXEC DBMS_SQLTUNE.PACK_STGTAB_SQLPROF (staging_table_name => 
   'SQL_PROFILES_TT',profile_name=>'SYS_SQLPROF_01601bcd34470000'); 

4. Export table using “exp” tool from the source database:

  exp SCOTT/TIGER file=SQL_PROFILES.dmp tables=SQL_PROFILES_TT

5. Import table using “imp” tool into the target database:

  imp SCOTT/REGIT file=SQL_PROFILES.dmp full=y

6. Unpack the SQL Profiles in the target database:

  EXEC DBMS_SQLTUNE.UNPACK_STGTAB_SQLPROF(REPLACE => TRUE,staging_table_name => 'SQL_PROFILES_TT');

Solaris Systems Wiki

User Tools

Site Tools

Page Tools