How to Move SQL Profiles from One Database to Another (Including to Higher Versions) (Doc ID 457531.1)
First create and accept a profile
create a staging table
pack the profile in table
move staging table using datapump from one database to other
import table
unpack staging table
SQLTXPLAN
SQLT Diagnostic Tool (Doc ID 215187.1)
Install sqltplan unzip sqlt
cd sqlt/install
sqdrop.sql
sqcreate.sql
Give details
Once completes
Goto cd sqlt/utl
@coe_xfr_profile.sql
enter sql id
run it before once so it will be cached
select hash
file will be created in same folder
move file to database you want and execute it
First create and accept a profile
create a staging table
pack the profile in table
move staging table using datapump from one database to other
import table
unpack staging table
SQLTXPLAN
SQLT Diagnostic Tool (Doc ID 215187.1)
Install sqltplan unzip sqlt
cd sqlt/install
sqdrop.sql
sqcreate.sql
Give details
Once completes
Goto cd sqlt/utl
@coe_xfr_profile.sql
enter sql id
run it before once so it will be cached
select hash
file will be created in same folder
move file to database you want and execute it
No comments:
Post a Comment