Follow below steps for migrating sql plan baselines from one database to another.

1. Get the sql_plan and sql_handle[SOURCE]

2. Create a staging table[SOURCE]

3. Pack the sql_plan to the staging table[SOURCE]

4. Take export of staging table[SOURCE]

5. Copy the dump file and import in the target database.[TARGET]

6. Unpack the staging table:[TARGET]

7. Check whether sql plan has been loaded or not[TARGET]

SIMILAR ARTICLE

Migrate sql profiles from one database to another:

Run sql tuning advisor for a sql_id

Change The Execution Plan Without Changing The Sql Query

MONITOR YOUR DB