Hello,
An exadata database server onpremise will be migrated to OCI As Is to the
same Oracle version (12.x).
I would like to know what else would have to be validated at OCI to ensure
that the migration was successful.
I thought I would check:
- dba_users
- dba_objects (and each object type separately)
- dba_tab_privs
- dba_sys_privs
- dba_roles
- dba_synonym
- dba_extents (in order to check the volumn)
- count the number of lines for each table, or to check at the dba_tables
numrows if the statistics are updated.
I guess that the number of lines migrated are enough to accept to
content of the table
The goal is to check only in the context of objects and not configuration
(v$parameters, tablespaces, resource manager and other structures).
What else could be validated?
Regards
Eriovaldo