Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Do SQL_IDs change during DB migration ?

PeaceMongerNov 5 2021

DB versions : 12.1, 19c 

Using expdp/impdp full export/import, I have moved a 12C database into a 19c pluggable database.
I have noticed that the SQL_IDs which are present in 12c and not in the newly migrated 19c DB.
Is this expected ? 

SELECT exact_matching_signature
           FROM  gv$sql
           WHERE sql_id = '84yukbw56t6j2'

The export was done SYS user . But, the import was done by non-SYS but privileged user. Could this be a reason ?

Comments
Post Details
Added on Nov 5 2021
7 comments
695 views