19.11 List of Checks Performed By the Premigration Advisor Tool

Review information about the checks you find in a Premigration Advisor Tool report.

Note:

When you specify the source database and your migration target, the Premigration Advisor Tool performs the checks required for that migration scenario. Only the checks required for that scenario are performed. Your report provides responses to the migration scenario you specify when you start CPAT.

• dp_has_low_streams_pool_size
  The Premigration Advisor Tool check dp_has_low_streams_pool_size verifies the STREAMS_POOL_SIZE amount is large enough for Data Pump migrations to start and work efficiently.
• gg_enabled_replication
  The Premigration Advisor Tool check gg_enabled_replication notifies you that the initialization parameter ENABLE_GOLDENGATE_REPLICATION is not set on the source database.
• gg_force_logging
  The Premigration Advisor Tool check gg_force_logging indicates that forced logging of all transactions and loads during the migration is not set.
• gg_has_low_streams_pool_size
  The Premigration Advisor Tool check gg_has_low_streams_pool_size verifies that the STREAMS_POOL_SIZE amount is large enough for Oracle GoldenGate.
• gg_not_unique_bad_col_no
  The Premigration Advisor Tool check gg_not_unique_bad_col_no finds tables that have no primary key and no non-nullable unique index.
• gg_not_unique_bad_col_yes
  The Premigration Advisor Tool check gg_not_unique_bad_col_yes finds tables that have no primary key, unique index, or key columns, including table columns defined with unbounded data types.
• gg_objects_not_supported
  The Premigration Advisor Tool check gg_objects_not_supported indicates that there are unsupported objects on the source database.
• gg_supplemental_log_data_min
  The Premigration Advisor Tool check gg_supplemental_log_data_min indicates that minimal supplemental logging is not enabled on the source database.
• gg_tables_not_supported
  The Premigration Advisor Tool check gg_tables_not_supported_adb indicates that some objects in the database cannot be replicated using Oracle GoldenGate.
• gg_tables_not_supported
  The Premigration Advisor Tool check gg_tables_not_supported indicates that some objects in the non-ADB database cannot be replicated using Oracle GoldenGate.
• gg_user_objects_in_ggadmin_schemas
  The Premigration Advisor Tool check gg_user_objects_in_ggadmin_schemas indicates the presence of user objects in schemas that have Oracle GoldenGate administrator privileges.
• has_absent_default_tablespace
  The Premigration Advisor Tool check has_absent_default_tablespace indicates that schema Owner default tablespaces are missing.
• has_absent_temp_tablespace
  The Premigration Advisor Tool check has_absent_temp_tablespace indicates that schema Owner temporary tablespaces are missing.
• has_active_data_guard_dedicated
  The Premigration Advisor Tool check has_active_data_guard_dedicated detects whether Active Data Guard is being used on the source instance.
• has_active_data_guard_serverless
  The Premigration Advisor Tool check has_active_data_guard_serverless detects whether Active Data Guard is being used on the source instance.
• has_basic_file_lobs
  The Premigration Advisor Tool check has_basic_file_lobs indicates BASICFILE LOBs are present in the schema, which are not supported with Oracle Autonomous Database.
• has_clustered_tables
  The Premigration Advisor Tool check has_clustered_tables indicates table clusters are present in the schema, which are not supported with Oracle Autonomous Database.
• has_columns_of_rowid_type
  The Premigration Advisor Tool check has_columns_of_rowid_type indicates tables with columns with ROWID data type that cannot be migrated.
• has_columns_with_media_data_types_adb
  The Premigration Advisor Tool check has_columns_with_media_data_types_adb indicates tables with multimedia data type that cannot be migrated.
• has_columns_with_media_data_types_default
  The Premigration Advisor Tool check has_columns_with_media_data_types_default indicates tables with multimedia columns.
• has_columns_with_spatial_data_types
  The Premigration Advisor Tool check has_columns_with_spatial_data_types indicates there are spatial objects that are not fully supported.
• has_common_objects
  The Premigration Advisor Tool check has_common_objects indicates there are common objects in the database instance.
• has_compression_disabled_for_objects
  The Premigration Advisor Tool check has_compression_disabled_for_objects indicates there are tables or partitions lacking a COMPRESSION clause.
• has_csmig_schema
  The Premigration Advisor Tool check has_csmig_schema indicates the CSSCAN utility is installed and configured on the source database..
• has_data_in_other_tablespaces_dedicated
  The Premigration Advisor Tool check has_data_in_other_tablespaces_dedicated identifies data subject to tablespace restrictions when migrating to Oracle Autonomous Databases on Dedicated Infrastructure..
• has_data_in_other_tablespaces_serverless
  The Premigration Advisor Tool check has_data_in_other_tablespaces_serverless identifies data subject to tablespace restrictions when migrating to Oracle Autonomous Databases on Shared Infrastructure.
• has_db_link_synonyms
  The Premigration Advisor Tool check has_db_link_synonyms indicates the schema contains synonyms with database links.
• has_db_links
  The Premigration Advisor Tool check has_db_links indicates the schema contains synonyms with database links.
• has_dbms_credentials
  The Premigration Advisor Tool check has_dbms_credentials indicates the schema contains credentials that were not created with DBMS_CLOUD.CREATE_CREDENTIAL.
• has_dbms_credentials
  The Premigration Advisor Tool check has_dbms_credentials indicates the schema contains credentials that were not created with DBMS_CLOUD.CREATE_CREDENTIAL.
• has_directories
  The Premigration Advisor Tool check has_directories indicates that there are directories objects in the source database.
• has_enabled_scheduler_jobs
  The Premigration Advisor Tool check has_enabled_scheduler_jobs indicates that there are List scheduler jobs that may interfere with Oracle Data Pump export.
• has_external_tables_dedicated
  The Premigration Advisor Tool check has_external_tables_dedicated indicates that Non-Cloud Objects Storage External tables exist in the source database.
• has_external_tables_default
  The Premigration Advisor Tool check has_external_tables_default indicates that external tables cannot be migrated unless the DIRECTORY objects the tables rely on have been created.
• has_external_tables_serverless
  The Premigration Advisor Tool check has_external_tables_serverless indicates that there are non-cloud Objects Storage external tables in the source database.
• has_fmw_registry_in_system
  The Premigration Advisor Tool check has_fmw_registry_in_system indicates that the Fusion Middleware Schema Version Registry must be moved out of the SYSTEM schema before migration.
• has_illegal_characters_in_comments
  The Premigration Advisor Tool check has_illegal_characters_in_comments indicates that there are characters in table comments that are not legal in the databases character set.
• has_ilm_ado_policies
  The Premigration Advisor Tool check has_ilm_ado_policies indicates that Information Lifestyle Management (ILM) Automatic Data Optimization Policies (ADO) will not migrate.
• has_incompatible_jobs
  The Premigration Advisor Tool check has_incompatible_jobs indicates that Information Lifestyle Management (ILM) Automatic Data Optimization Policies (ADO) will not migrate.
• has_index_organized_tables
  The Premigration Advisor Tool check has_index_organized_tables indicates that Index Organized tables are present in the source database.
• has_java_objects
  The Premigration Advisor Tool check has_java_objects indicates that there are Java objects present in the source database.
• has_java_source
  The Premigration Advisor Tool check has_java_source indicates that there are Java sources present in the source database.
• has_libraries
  The Premigration Advisor Tool check has_libraries indicates that there are applications that require the CREATE LIBRARY statement.
• has_logging_off_for_partitions
  The Premigration Advisor Tool check has_logging_off_for_partitions indicates that there are Partitions using the NOLOGGING storage attribute.
• has_logging_off_for_subpartitions
  The Premigration Advisor Tool check has_logging_off_for_subpartitions indicates that there are Partitions using the NOLOGGING storage attribute.
• has_logging_off_for_tables
  The Premigration Advisor Tool check has_logging_off_for_tables indicates that there are tables using the NOLOGGING storage attribute.
• has_low_streams_pool_size
  The Premigration Advisor Tool check has_low_streams_pool_size indicates that Mining Models with unexpected or incorrect attributes are detected.
• has_noexport_object_grants
  The Premigration Advisor Tool check has_noexport_object_grants indicates that Oracle Data Pump is unable to export all object grants.
• has_parallel_indexes_enabled
  The Premigration Advisor Tool check has_parallel_indexes_enabled indicates that PARALLEL clause indexes exist.
• has_profile_not_default
  The Premigration Advisor Tool check has_profile_not_default indicates that schemas exist whose PROFILE is not available on the target system.
• has_public_synonyms
  The Premigration Advisor Tool check has_public_synonyms indicates that Public Synonyms exist in source system schemas.
• has_refs_to_restricted_packages_dedicated
  The Premigration Advisor Tool check has_refs_to_restricted_packages_dedicated indicates that there are references to partially or completely unsupported packages.
• has_refs_to_restricted_packages_serverless
  The Premigration Advisor Tool check has_refs_to_restricted_packages_serverless indicates that there are references to partially or completely unsupported packages.
• has_refs_to_user_objects_in_sys
  The Premigration Advisor Tool check has_refs_to_user_objects_in_sys indicates that there are user schema objects dependent on SYS or SYSTEM.
• has_role_privileges
  The Premigration Advisor Tool check has_role_privileges indicates that some role privileges used in the source database are not available in the target database
• has_sqlt_objects_adb
  The Premigration Advisor Tool check has_sqlt_objects_adb indicates that SQLTXPLAIN objects are detected.
• has_sqlt_objects_default
  The Premigration Advisor Tool check has_sqlt_objects_default indicates that SQLTXPLAIN objects are detected that Oracle Data Pump does not export.
• has_sys_privileges
  The Premigration Advisor Tool check has_sys_privileges indicates that some system privileges in the source database are not available in the target database.
• has_tables_that_fail_with_dblink
  The Premigration Advisor Tool check has_tables_that_fail_with_dblink indicates that there are tables with LONG or LONG RAW data types
• has_tables_with_long_raw_datatype
  The Premigration Advisor Tool check has_tables_with_long_raw_datatype indicates that there are tables with LONG or LONG RAW data types
• has_tables_with_xmltype_column
  The Premigration Advisor Tool check has_tables_with_xmltype_column indicates that there are tables with XMLTYPE columns.
• has_trusted_server_entries
  The Premigration Advisor Tool check has_trusted_server_entries indicates that there areTRUSTED_SERVER entries that cannot be recreated on Oracle Autonomous Database.
• has_user_defined_objects_in_sys
  The Premigration Advisor Tool check has_user_defined_objects_in_sys indicates that there are User-defined objects in the SYS or SYSTEM schemas.
• has_users_with_10g_password_version
  The Premigration Advisor Tool check has_users_with_10g_password_version indicates that there are user accounts using 10G password version.
• has_sys_privileges
  The Premigration Advisor Tool check has_sys_privileges indicates that some system privileges in the source database are not available in the target database.
• has_tables_that_fail_with_dblink
  The Premigration Advisor Tool check has_tables_that_fail_with_dblink indicates that there are tables with LONG or LONG RAW data types
• has_tables_with_long_raw_datatype
  The Premigration Advisor Tool check has_tables_with_long_raw_datatype indicates that there are tables with LONG or LONG RAW data types
• has_tables_with_xmltype_column
  The Premigration Advisor Tool check has_tables_with_xmltype_column indicates that there are tables with XMLTYPE columns.
• has_trusted_server_entries
  The Premigration Advisor Tool check has_trusted_server_entries indicates that there areTRUSTED_SERVER entries that cannot be recreated on Oracle Autonomous Database.
• has_user_defined_objects_in_sys
  The Premigration Advisor Tool check has_user_defined_objects_in_sys indicates that there are User-defined objects in the SYS or SYSTEM schemas.
• has_users_with_10g_password_version
  The Premigration Advisor Tool check has_users_with_10g_password_version indicates that there are user accounts using 10G password version.
• has_xmlschema_objects
  The Premigration Advisor Tool check has_xmlschema_objects indicates that there are XML Schema Objects in the source database.
• has_xmltype_tables
  The Premigration Advisor Tool check has_xmltype_tables indicates that there are XMLType tables in the source database.
• modified_db_parameters_dedicated
  The Premigration Advisor Tool check modified_db_parameters_dedicated indicates that restricted initialization parameters are modified.
• modified_db_parameters_serverless
  The Premigration Advisor Tool check modified_db_parameters_serverless indicates that restricted initialization parameters are modified.
• nls_character_set_conversion
  The Premigration Advisor Tool check nls_character_set_conversion indicates that there are character codes on the source database that are invalid in Oracle Autonomous Database.
• nls_national_character_set
  The Premigration Advisor Tool check nls_national_character_set indicates that the NCHAR and NVARCHAR2 lengths are different on the source and target databases.
• nls_nchar_ora_910
  The Premigration Advisor Tool check nls_nchar_ora_910 indicates that the NCHAR and NVARCHAR2 lengths are greater than the maximum length on the target databases.
• options_in_use_not_available_dedicated
  The Premigration Advisor Tool check options_in_use_not_available_dedicated indicates that unavailable database options are present on the source database.
• options_in_use_not_available_serverless
  The Premigration Advisor Tool check options_in_use_not_available_serverless indicates that unavailable database options are present on the source database.
• standard_traditional_audit_adb
  The Premigration Advisor Tool check standard_traditional_audit_adb indicates that Traditional Audit configurations are detected in the database.
• standard_traditional_audit_default
  The Premigration Advisor Tool check standard_traditional_audit_default indicates that Traditional Audit configurations are detected in the database.
• timezone_table_compatibility_higher_dedicated
  The Premigration Advisor Tool check timezone_table_compatibility_higher_dedicated indicates that the timezone setting is a more recent version on the source than on the target database.
• timezone_table_compatibility_higher_default
  The Premigration Advisor Tool check timezone_table_compatibility_higher_default indicates that the timezone setting is a more recent version on the source than on the target database.
• timezone_table_compatibility_higher_serverless
  The Premigration Advisor Tool check timezone_table_compatibility_higher_serverless indicates that the timezone setting is a more recent version on the source than on the target database.
• unified_and_standard_traditional_audit_adb
  The Premigration Advisor Tool check unified_and_standard_traditional_audit_adb indicates that Traditional Audit configurations are detected in the database.
• unified_and_standard_traditional_audit_default
  The Premigration Advisor Tool check unified_and_standard_traditional_audit_default indicates that Traditional Audit configurations are detected in the database.
• xdb_resource_view_has_entries Check
  The Premigration Advisor Tool check xdb_resource_view_has_entries Check indicates that there is an XDB Repository that is not supported in Oracle Autonomous Database. Entries in RESOURCE_VIEW will not migrate.

19.11.1 dp_has_low_streams_pool_size

The Premigration Advisor Tool check dp_has_low_streams_pool_size verifies the STREAMS_POOL_SIZE amount is large enough for Data Pump migrations to start and work efficiently.

Result Criticality

Runtime

Has Fixup

Yes

Scope

UNIVERSAL

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

The Premigration Advisor Tool check dp_has_low_streams_pool_size verifies the STREAMS_POOL_SIZE has been preallocated to an amount is large enough for Oracle Data Pump migrations to start and work efficiently.

Effect

The database initialization parameter STREAMS_POOL_SIZE value helps determine the size of the Streams pool. You should allocate sufficient memory to STREAMS_POOL_SIZE for the export. Failure to do this can reduce Oracle Data Pump export performance, or cause the export to fail. Oracle recommends that you define a minimum value for STREAMS_POOL_SIZE in the source database before export.

Action

Run SQL to set STREAMS_POOL_SIZE to allocate memory for the export. For example:

ALTER SYSTEM SET streams_pool_size=256M SCOPE=BOTH

After allocating memory, restart your instance if necessary.

19.11.2 gg_enabled_replication

The Premigration Advisor Tool check gg_enabled_replication notifies you that the initialization parameter ENABLE_GOLDENGATE_REPLICATION is not set on the source database.

Result Criticality

Action required

Has Fixup

Yes

Scope

UNIVERSAL

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

The Premigration Advisor Tool gg_enabled_replication check indicates that you have selected Oracle GoldenGate as your migration method, but the initialization parameter ENABLE_GOLDENGATE_REPLICATION is not set to TRUE.

Effect

For Oracle GoldenGate to perform data migration, the source database initialization parameter ENABLE_GOLDENGATE_REPLICATION must be set to TRUE. If it is not set, then the migration fails.

Action

Set ENABLE_GOLDENGATE_REPLICATION to TRUE in the database initialization file.

19.11.3 gg_force_logging

The Premigration Advisor Tool check gg_force_logging indicates that forced logging of all transactions and loads during the migration is not set.

Result Criticality

Review required

Has Fixup

Yes

Target Cloud

This is a default check. It applies to the following:

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Scope

UNIVERSAL

Description

Forced logging mode is not set on the source database. When force logging mode is set, this forces the logging of all transactions and loads, overriding any user or storage settings that indicate these transactions and loads should not be logged.

Effect

If forced logging is not set, then source data in the Oracle GoldenGate Extract configuration may be missed during the migration.

Action

To enable forced logging at tablespace and database level, log in as SYSDBA, and turn on forced logging. For example:

SQL> alter database force logging;
Database altered.

19.11.4 gg_has_low_streams_pool_size

The Premigration Advisor Tool check gg_has_low_streams_pool_size verifies that the STREAMS_POOL_SIZE amount is large enough for Oracle GoldenGate.

Result Criticality

Runtime

Has Fixup

Yes

Scope

UNIVERSAL

Target Cloud

This is a default check. It applies to the following:

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

The Premigration Advisor Tool check gg_has_low_streams_pool_size verifies the STREAMS_POOL_SIZE has been preallocated to an amount is large enough for Oracle GoldenGate migrations to start and work efficiently.

Oracle GoldenGate Extract interacts with an underlying logmining server in the source database, and Replicat interacts with an inbound server in the target database.

The shared memory that is used by the servers comes from the Streams pool portion of the System Global Area (SGA) in the database.Therefore, you must set the database initialization parameter STREAMS_POOL_SIZE high enough to keep enough memory available for the number of Extract and Replicat processes that you expect to run in integrated mode. Note that Streams pool is also used by other components of the database (including Oracle Streams, Advanced Queuing, and Oracle Data Pump export/import), so take other components into account when sizing the Streams pool for Oracle GoldenGate.

By default, one Extract requests the logmining server to run with of 1GB. As a best practice, keep 25 percent of the Streams pool available. Therefor, for a single process the minimum STREAMS_POOL_SIZE would be 1.25 GB. For more information see Oracle Support Document ID 2078459.1 and the Oracle GoldenGate documentation.

Effect

Allocate sufficient memory to STREAMS_POOL_SIZE for Oracle GoldenGate processes. Failure to do this can reduce Oracle GoldenGate performance, or cause the Extract or Replicat to fail. Oracle recommends that you define a minimum value for STREAMS_POOL_SIZE in the source database before running Oracle GoldenGate

Action

Run SQL to set STREAMS_POOL_SIZE to allocate memory for Extract and Replicat, depending on the number of Oracle GoldenGate processes that will run. For example:

ALTER SYSTEM SET streams_pool_size=1250M SCOPE=BOTH; 

After allocating memory, restart your instance if necessary.

19.11.5 gg_not_unique_bad_col_no

The Premigration Advisor Tool check gg_not_unique_bad_col_no finds tables that have no primary key and no non-nullable unique index.

Result Criticality

Review required

Has Fixup

No

Scope

SCHEMA

Target Cloud

This is a default check. It applies to the following:

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Migration Method

GOLDENGATE

Description

The Premigration Advisor Tool check gg_not_unique_bad_col_no finds tables that have no primary key and no non-nullable unique index.

High amounts of mutations on the tables identified in this check can cause GoldenGate replication to fall behind and never catch up. A full table scan is needed to replicate every INSERT, UPDATE, or DELETE operation.

Effect

If Oracle GoldenGate has to perform significant changes on these tables, then it can fall behind progressively as the replication continues, and not recover.

Action

To address this issue, do one of the following:

• Add a primary key to the listed tables
• Quiesce the database as much as possible during migration
• Migrate changes to the tables using another method, such as Oracle Data Pump

19.11.6 gg_not_unique_bad_col_yes

The Premigration Advisor Tool check gg_not_unique_bad_col_yes finds tables that have no primary key, unique index, or key columns, including table columns defined with unbounded data types.

Result Criticality

Action required

Has Fixup

No

Scope

SCHEMA

Target Cloud

This is a default check. It applies to the following:

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

The Premigration Advisor Tool check gg_not_unique_bad_col_yes finds tables that have no Primary Key, Unique Index or Key Columns. A Problematic Column indicates that the table has a column not useful in the predicate (where clause). The table column is defined using an unbounded data type, such as LONG or BLOB.

Effect

If there are tables without any uniqueness, and with unbounded data_types, then the table records cannot be uniquely identified and cannot be used for logical replication. These tables are not supported in the Oracle GoldenGate Guide for Oracle Databases, and cannot be migrated using Oracle GoldenGate

Action

To address this issue, if possible add a primary or unique key to the tables. If you cannot add a primary or uniquen key, then you must use some other method of migrating the tables, such as Oracle Data Pump.

19.11.7 gg_objects_not_supported

The Premigration Advisor Tool check gg_objects_not_supported indicates that there are unsupported objects on the source database.

Result Criticality

Action required

Has Fixup

No

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Scope

SCHEMA

Description

This check applies to schemas for Oracle GoldenGate migrations. Objects exist on the source database that are not supported for migration with Oracle GoldenGate.

Effect

Typically, the objects listed under this check are not replicated successfully in the migration without additional configuration.

Action

Consult the Oracle GoldenGate documentation to see how objects with the listed SUPPORT_MODE values can be replicated successfully.

19.11.8 gg_supplemental_log_data_min

The Premigration Advisor Tool check gg_supplemental_log_data_min indicates that minimal supplemental logging is not enabled on the source database.

Result Criticality

Action required

Has Fixup

Yes

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Scope

UNIVERSAL

Description

This check applies to schemas for Oracle GoldenGate migrations. Minimal supplemental logging, a database-level option, is required for an Oracle source database when using Oracle GoldenGate. This configuration adds row chaining information, if any exists, to the redo log for update operations.

Effect

If minimal supplemental log data is not enabled, then Oracle GoldenGate cannot function.

Action

Log in as SYSDBA, and enable minimal supplemental logging on the source database. For example:

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

19.11.9 gg_tables_not_supported

The Premigration Advisor Tool check gg_tables_not_supported_adb indicates that some objects in the database cannot be replicated using Oracle GoldenGate.

Result Criticality

Action required

Has Fixup

No

Target Cloud

This is a default check. It applies to the following:

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Scope

SCHEMA

Description

This check applies to schemas for Oracle GoldenGate migrations. When objects in the source database cannot be replicated by Oracle GoldenGate, the report provides a list of those objects with this check message.

Effect

The listed objects will not be migrated with Oracle GoldenGate.

Action

At the time of the switchover, you must move the listed relevant objects to the target database using another migration method, such as Oracle Data Pump.

19.11.10 gg_tables_not_supported

The Premigration Advisor Tool check gg_tables_not_supported indicates that some objects in the non-ADB database cannot be replicated using Oracle GoldenGate.

Result Criticality

Action required

Has Fixup

No

Target Cloud

• Default (an Oracle Database instance that is not Oracle Autonomous Database, or ADB)

Scope

SCHEMA

Description

This check applies to schemas for Oracle GoldenGate migrations. When objects in the source database cannot be replicated by Oracle GoldenGate, the report provides a list of those objects with this check message.

Effect

The listed objects will not be migrated with Oracle GoldenGate.

Action

At the time of the switchover, you must move the listed relevant objects to the target database using another migration method, such as Oracle Data Pump.

19.11.11 gg_user_objects_in_ggadmin_schemas

The Premigration Advisor Tool check gg_user_objects_in_ggadmin_schemas indicates the presence of user objects in schemas that have Oracle GoldenGate administrator privileges.

Result Criticality

Action required

Has Fixup

No

Target Cloud

This is a default check. It applies to the following:

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Scope

SCHEMA

Description

This check applies to schemas for Oracle GoldenGate migrations. When user objects in schemas have Oracle GoldenGate administrator privileges, those schemas are listed in CPAT report. Oracle GoldenGate cannot migrate them.

Effect

The listed objects will not be migrated with Oracle GoldenGate.

Action

Exclude these schemas from the Oracle GoldenGate data migration. You must move the listed relevant objects to the target database using another migration method, such as Oracle Data Pump.

19.11.12 has_absent_default_tablespace

The Premigration Advisor Tool check has_absent_default_tablespace indicates that schema Owner default tablespaces are missing.

Result Criticality

Review required.

Has Fixup

No

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ATPD Autonomous Transaction Processing Dedicated
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Scope

SCHEMA

Description

This check applies to schemas for Oracle Data Pump and Oracle GoldenGate migrations. When CPAT detects that one or more schema Owner's default tablespace are missing, the schemas are listed in the report.

Effect

Schemas without a valid DEFAULT TABLESPACE cannot be created on the target instance due to ORA-00959 errors..

Action

If the schemas are no longer being used, then drop those schemas. However, if the schemas are being used, then either create a valid default tablespace for the schema, or define default tablespace by running a query on DBA_TABLESPACE to list all valid tablespace names, and select one as a valid default tablespace.

19.11.13 has_absent_temp_tablespace

The Premigration Advisor Tool check has_absent_temp_tablespace indicates that schema Owner temporary tablespaces are missing.

Result Criticality

Review required.

Has Fixup

No

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ATPD Autonomous Transaction Processing Dedicated
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Scope

SCHEMA

Description

This check applies to schemas for Oracle Data Pump and Oracle GoldenGate migrations. When CPAT detects that one or more schema Owner's temporary tablespace are missing, the schemas are listed in the report.

Effect

For Oracle Autonomous Database Dedicated Infrastructure for Transaction Processing (ATPD) and Oracle Autonomous Database Dedicated Infrastructure for Data Warehouse (ADWD), unless the needed temporary tablespaces have been created before migration on the target the source database schemas without a valid TEMPORARY TABLESPACE cannot be created on the target instance due to ORA-00959 errors.

Action

Create the needed temporary tablespaces on the Oracle Autonomous Database Dedicated infrastructure before you start the migration, or use tablespace remapping parameters to map other tablespaces into the TEMP tablespace when you start migration tools. Oracle Zero Downtime Migration and Database Migration Service can perform tablespace precreation and mapping automatically as part of the migration.

19.11.14 has_active_data_guard_dedicated

The Premigration Advisor Tool check has_active_data_guard_dedicated detects whether Active Data Guard is being used on the source instance.

Result Criticality

Review suggested.

Has Fixup

No

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ATPD Autonomous Transaction Processing Dedicated

Scope

INSTANCE

Description

This check detects whether Active Data Guard is being used on the source instance.

Effect

If applications or schemas that are being migrated depend on certain capabilities of Active Data Guard, then those applications may no longer work after migration.

Action

Consider using Autonomous Data Guard on your target Oracle Autonomous Database instance. For more information, and to evaluate the capabilities of Autonomous Data Guard, see "Protect Critical Databases from Failures and Disasters Using Autonomous Data Guard" in Oracle Cloud Oracle Autonomous Database on Dedicated Exadata Infrastructure.

19.11.15 has_active_data_guard_serverless

The Premigration Advisor Tool check has_active_data_guard_serverless detects whether Active Data Guard is being used on the source instance.

Result Criticality

Review suggested.

Has Fixup

No

Target Cloud

• ADWS Autonomous Data Warehouse Shared
• ATPS Autonomous Transaction Processing Shared

Scope

INSTANCE

Description

This check detects whether Active Data Guard is being used on the source instance.

Effect

If applications or schemas that are being migrated depend on certain capabilities of Active Data Guard, then those applications may no longer work after migration.

Action

Consider using Autonomous Data Guard on your target Oracle Autonomous Database instance. For more information, and to evaluate the capabilities of Autonomous Data Guard, see "Using Standby Databases with Autonomous Database for Disaster Recovery " in Oracle Cloud Using Oracle Autonomous Database on Shared Exadata Infrastructure.

19.11.16 has_basic_file_lobs

The Premigration Advisor Tool check has_basic_file_lobs indicates BASICFILE LOBs are present in the schema, which are not supported with Oracle Autonomous Database.

Result Criticality

Review required.

Has Fixup

No

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Scope

SCHEMA

Description

This check applies to schemas for Oracle Data Pump and Oracle GoldenGate migrations. When CPAT detects that one or more schema Owner's temporary tablespace contain BASICFILE LOBs, the schemas are listed in the report. .

Effect

During migration, all BASICFILE LOBs are converted automatically to SECUREFILE LOBs at the time of the import.

Action

No action is required.

19.11.17 has_clustered_tables

The Premigration Advisor Tool check has_clustered_tables indicates table clusters are present in the schema, which are not supported with Oracle Autonomous Database.

Result Criticality

Review suggested.

Has Fixup

No

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Scope

SCHEMA

Description

This check applies to schemas for Oracle Data Pump and Oracle GoldenGate migrations. When CPAT detects that one or more schema s contain table clusters, the schemas are listed in the report. .

Effect

When tables are created with a CLUSTER clause on the Oracle Autonomous Database, the table is created as a regular table.

Action

No action is required. Consider doing some performance testing to ensure that there are no adverse effects.

19.11.18 has_columns_of_rowid_type

The Premigration Advisor Tool check has_columns_of_rowid_type indicates tables with columns with ROWID data type that cannot be migrated.

Result Criticality

Action required.

Has Fixup

Yes

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ATPD Autonomous Transaction Processing Dedicated

Scope

SCHEMA

Description

This check applies to schemas for Oracle Data Pump and Oracle GoldenGate migrations. The ROWID data type is not enabled by default in Oracle Autonomous Database on Dedicated Exadata Infrastructure deployments.

Effect

By default, columns with ROWID data type cannot be migrated to ATPD or ADWD.

Action

You can choose to enable the ROWID data type by setting the initialization parameter ALLOW_ROWID_COLUMN_TYPE to true on the target ADBD instance. However, if you do enable it, then be aware that ROWID columns are incompatible with rolling upgrade operations, and other internal operations that physically move a row. At a minimum, during upgrades, Oracle recommends that you suspend database activities involving ROWID. Applications using ROWID columns should introduce correctness validation to check for logical errors in the application if a row relocates.

19.11.19 has_columns_with_media_data_types_adb

The Premigration Advisor Tool check has_columns_with_media_data_types_adb indicates tables with multimedia data type that cannot be migrated.

Result Criticality

Action required.

Has Fixup

No

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Scope

SCHEMA

Description

This check applies to schemas for Oracle Data Pump and Oracle GoldenGate migrations. Multimedia object types such as those from ORDSYS cannot be used in Oracle Autonomous Database.

Effect

Migration of tables with multimedia columns will fail.

Action

Columns with media data types are not allowed in Oracle Autonomous Database. As an alternative, Oracle recommends that you consider using SecureFiles LOBs for media type storage.

Follow the instructions in the Oracle Multimedia README.txt file in Oracle_home/ord/im/admin/README.txt, or Oracle Support Document ID 2555923.1 to determine if Oracle Multimedia methods and packages are being used. If Oracle Multimedia is being used, then refer to Oracle Support Document ID 2347372.1 for suggestions on replacing Oracle Multimedia. Refer to Oracle Support Document ID 2375644.1 "How To Migrate Data From Oracle Multimedia Data Types to BLOB columns" for information on how to move data stored in Oracle Multimedia object types to SecureFiles LOBs.

19.11.20 has_columns_with_media_data_types_default

The Premigration Advisor Tool check has_columns_with_media_data_types_default indicates tables with multimedia columns.

Result Criticality

Action required.

Has Fixup

No

Scope

SCHEMA

Target Cloud

• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

This check applies to schemas for Oracle Data Pump and Oracle GoldenGate migrations. Multimedia object types such as those from ORDSYS are desupported in Oracle Database 19c and later releases.

Effect

Migration of tables with multimedia columns can fail.

Action

Oracle Multimedia was desupported in Oracle Database 19c. Oracle recommends that you consider using SecureFiles LOBs for media type storage.

Follow the instructions in the Oracle Multimedia README.txt file in Oracle_home/ord/im/admin/README.txt, or Oracle Support Document ID 2555923.1 to determine if Oracle Multimedia methods and packages are being used. If Oracle Multimedia is being used, then refer to Oracle Support Document ID 2347372.1 for suggestions on replacing Oracle Multimedia. Refer to Oracle Support Document ID 2375644.1 "How To Migrate Data From Oracle Multimedia Data Types to BLOB columns" for information on how to move data stored in Oracle Multimedia object types to SecureFiles LOBs.

19.11.21 has_columns_with_spatial_data_types

The Premigration Advisor Tool check has_columns_with_spatial_data_types indicates there are spatial objects that are not fully supported.

Result Criticality

Review required.

Has Fixup

Yes

Target Cloud

• ADWS Autonomous Data Warehouse Shared
• ATPS Autonomous Transaction Processing Shared

Scope

SCHEMA

Description

This check applies to schemas for Oracle Data Pump and Oracle GoldenGate migrations. It indicates the presence of spatial data type objects.

Effect

Because some of the functionality of spatial objects are dependent on the Oracle Java (JAVAVM) feature, there can be objects not fully supported with Oracle Autonomous Databases on Shared Infrastructure until JAVAVM is enabled.

Action

Enable the JAVAVM feature on the target system by running this SQL, and then restart your instance:

BEGIN
   DBMS_CLOUD_ADMIN.ENABLE_FEATURE(
       feature_name => 'JAVAVM' );
END;
/

For more information on enabling the JAVAVM feature see "Using Oracle Java on Autonomous Database" in Oracle Cloud Using Oracle Autonomous Database Serverless For more information on using Spatial on ADB, see "Use Oracle Spatial with Autonomous Database" in Oracle Cloud Using Oracle Autonomous Database Serverless.

19.11.22 has_common_objects

The Premigration Advisor Tool check has_common_objects indicates there are common objects in the database instance.

Result Criticality

Action required.

Has Fixup

Yes

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Scope

INSTANCE

Description

This is a default check. This check applies to source instances for Oracle Data Pump and Oracle GoldenGate migrations. It indicates the presence of common objects.

Effect

Oracle Data Pump does not migrate common objects to Oracle Autonomous Database in Oracle Cloud, and these objects are not supported on Oracle Autonomous Database (ADB). Anything dependent on the common objects will fail to be migrated properly.

Action

Those common objects needed by applications must be recreated on the target system before you start the migration. When targeting ADB, the common objects that you require must be recreated as local objects. This can be done using DBMS_METADATA.GET_DDL, as shown in Oracle Support Document ID 2739952.1

19.11.23 has_compression_disabled_for_objects

The Premigration Advisor Tool check has_compression_disabled_for_objects indicates there are tables or partitions lacking a COMPRESSION clause.

Result Criticality

Review suggested.

Has Fixup

No

Target Cloud

• ADWS Autonomous Data Warehouse Shared
• ATPS Autonomous Transaction Processing Shared

Scope

SCHEMA

Description

This check applies to source schema for Oracle Data Pump and Oracle GoldenGate migrations. It indicates the presence of tables or partitions that do not have a COMPRESSION clause. Tables and Partitions must be compressed to QUERY HIGH in Oracle Autonomous Data Warehouse (ADW).

Effect

When migrating to ADW, if a table or partition SQL data definition language (DDL) statement does not contain a COMPRESSION clause, then it is created during the migration with a default compression of QUERY HIGH.

Action

No action required. To modify this behavior, either add a compression clause of your choice (or even NOCOMPRESS) before starting the export, or alter the compression clause after the import..

19.11.24 has_csmig_schema

The Premigration Advisor Tool check has_csmig_schema indicates the CSSCAN utility is installed and configured on the source database..

Result Criticality

Review suggested.

Has Fixup

Yes

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Scope

UNIVERSAL

Description

This is a default check. The CSSCAN utility is no longer supported, and has been replaced by the Database Migration Assistant for Unicode (DMU) Tool..

Effect

Migration tools can ignore any objects, users, or roles related with CSSCAN utility.

Action

Remove the CSMIG user and any objects created by the CSSCAN utility: For example:

BEGIN FOR REC IN (SELECT SYNONYM_NAME FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'CSMIG') LOOP
      EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM ' || REC.SYNONYM_NAME; END LOOP; END; / DROP VIEW
      SYS.CSMV$KTFBUE; DROP USER CSMIG CASCADE; 

Use The Database Migration Assistant for Unicode (DMU) Tool to scan for character set migration issues. For more information on DMU see Oracle Support Document ID 1272374.1

19.11.25 has_data_in_other_tablespaces_dedicated

The Premigration Advisor Tool check has_data_in_other_tablespaces_dedicated identifies data subject to tablespace restrictions when migrating to Oracle Autonomous Databases on Dedicated Infrastructure..

Result Criticality

Action required.

Has Fixup

No

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ATPD Autonomous Transaction Processing Dedicated

Scope

SCHEMA

Description

This check applies to source schema for Oracle Data Pump and Oracle GoldenGate migrations. It indicates the presence of data that is subject to tablespace restrictions when migrating to Autonomous Databases on Dedicated Infrastructure.

Effect

For ATPD and ADWD (Dedicated Infrastructure), errors are reported for tablespaces that have not been precreated on the target. If tablespace mapping is not employed, then errors can occur during migration.

Action

If you are migrating the database using either Zero Downtime Migration (ZDM) or Database Migration Service (DMS) then they precreate and map tablespaces automatically, so the issue does not occur.

If you are migrating using Oracle Data Pump manually, then specify IGNORE=TABLESPACE and REMAP_TABLESPACE='%:DATA' in your Data Pump impdp parameter file, so that other tablespaces into the DATA tablespace when starting migration tooling.

In all cases, you should assess your application for any dependencies on specific tablespace names.

19.11.26 has_data_in_other_tablespaces_serverless

The Premigration Advisor Tool check has_data_in_other_tablespaces_serverless identifies data subject to tablespace restrictions when migrating to Oracle Autonomous Databases on Shared Infrastructure.

Result Criticality

Action required.

Has Fixup

No

Target Cloud

• ADWS Autonomous Data Warehouse Shared
• ATPS Autonomous Transaction Processing Shared

Scope

SCHEMA

Description

This check applies to source schema for Oracle Data Pump and Oracle GoldenGate migrations. It indicates the presence of tables that have other tablespaces mapped into their table.

Effect

User-defined tablespaces are not allowed in ATPS and ADWS (Serverless Infrastructure). Each database in this cloud environment has a single 'DATA' tablespace. If tablespace mapping is not employed, and the user performing migration does not have privileges on the DATA tablespace, then errors can occur during migration.

Action

If you are migrating the database using either Zero Downtime Migration (ZDM) or Database Migration Service (DMS) then they precreate and map tablespaces automatically, so the issue does not occur.

If you are migrating using Oracle Data Pump manually, then specify IGNORE=TABLESPACE and REMAP_TABLESPACE='%:DATA' in your Data Pump impdp parameter file, so that other tablespaces into the DATA tablespace when starting migration tooling.

In all cases, you should assess your application for any dependencies on specific tablespace names.

19.11.27 has_db_link_synonyms

The Premigration Advisor Tool check has_db_link_synonyms indicates the schema contains synonyms with database links.

Result Criticality

Review suggested.

Has Fixup

Yes

Target Cloud

• ADWS Autonomous Data Warehouse Shared
• ATPS Autonomous Transaction Processing Shared

Scope

SCHEMA

Description

This check applies to source schema for Oracle Data Pump and Oracle GoldenGate migrations. Database links cannot be migrated.

Effect

After migration, applications relying on the synonym will fail until the database links are recreated.

Action

After migration is complete, create database links in the target Oracle Autonomous Database in using DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK, and then recreate the synonyms.

19.11.28 has_db_links

The Premigration Advisor Tool check has_db_links indicates the schema contains synonyms with database links.

Result Criticality

Review required

Has Fixup

No

Target Cloud

• ADWS Autonomous Data Warehouse Shared
• ATPS Autonomous Transaction Processing Shared

Scope

SCHEMA

Description

This check applies to source schema for Oracle Data Pump and Oracle GoldenGate migrations. Database links cannot be migrated.

Effect

After migration, applications relying on database links will fail until the database links are recreated.

Action

Precreate Database Links manually in ADB using DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK in the respective database schemas before migrating. The proper sequence of statements is as follows:

1. Create the schemas that own the links.
2. Create the links using DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK.
3. Import the schemas that you are migrating.

19.11.29 has_dbms_credentials

The Premigration Advisor Tool check has_dbms_credentials indicates the schema contains credentials that were not created with DBMS_CLOUD.CREATE_CREDENTIAL.

Result Criticality

Review required

Has Fixup

No

Target Cloud

• ADWS Autonomous Data Warehouse Shared
• ATPS Autonomous Transaction Processing Shared

Scope

SCHEMA

Description

This check applies to source schema for Oracle Data Pump and Oracle GoldenGate migrations. Credentials originally created with DBMS_CREDENTIAL or DBMS_SCHEDULER packages cannot be automatically migrated to Oracle Autonomous Database.

Effect

After migration, users with credentials originally created with DBMS_CREDENTIAL or DBMS_SCHEDULER packages receive ORA-27486: insufficient privileges errors. These credentials cannot be migrated automatically to ADBS.

Action

After migration is complete, verify that the listed credentials are still required on the target Oracle Autonomous Database instance. If these credentials are required, then recreate the credentials using DBMS_CLOUD.CREATE_CREDENTIAL. For more information, see My Oracle Support Document ID 2746284.1.

19.11.30 has_dbms_credentials

The Premigration Advisor Tool check has_dbms_credentials indicates the schema contains credentials that were not created with DBMS_CLOUD.CREATE_CREDENTIAL.

Result Criticality

Review required

Has Fixup

No

Target Cloud

• ADWS Autonomous Data Warehouse Shared
• ATPS Autonomous Transaction Processing Shared

Scope

SCHEMA

Description

This check applies to source schema for Oracle Data Pump and Oracle GoldenGate migrations. Credentials originally created with DBMS_CREDENTIAL or DBMS_SCHEDULER packages cannot be automatically migrated to Oracle Autonomous Database.

Effect

After migration, users with credentials originally created with DBMS_CREDENTIAL or DBMS_SCHEDULER packages receive ORA-27486: insufficient privileges errors. The schema Owner's default tablespace must be 'DATA'.

Action

The schema owner's DEFAULT TABLESPACE will be modified in ADB to be 'DATA'. If a user has quota on multiple tablespaces, then after migration is complete, ensure that the proper quota is set.

19.11.31 has_directories

The Premigration Advisor Tool check has_directories indicates that there are directories objects in the source database.

Result Criticality

Review required

Has Fixup

No

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Scope

INSTANCE

Description

This check indicates that there are directories objects in the source database.

Effect

After migration, applications that rely on the directories will not work until the directories on the source database are recreated on the target database.

Action

After migration is complete, recreate the directories on the Oracle Autonomous Database instance.

19.11.32 has_enabled_scheduler_jobs

The Premigration Advisor Tool check has_enabled_scheduler_jobs indicates that there are List scheduler jobs that may interfere with Oracle Data Pump export.

Result Criticality

Review suggested

Has Fixup

No

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Scope

INSTANCE

Description

This is a default check. This check indicates that there are List scheduler jobs that may interfere with Oracle Data Pump export.

Effect

If a scheduler job runs at the same time as a FULL export is under way, then Oracle Data Pump Export can fail with an ORA-39127 error.

Action

Disable any non-critical scheduler jobs, or plan the export at a time when you are certain that no scheduler jobs are running. Either stop scheduler jobs before the migration, or plan the export for a time when you are certain that no scheduler jobs are running.

You can run the following SQL statement to ensure no Scheduler Jobs are running during migration:

ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

No restart is required after you run the statement.

19.11.33 has_external_tables_dedicated

The Premigration Advisor Tool check has_external_tables_dedicated indicates that Non-Cloud Objects Storage External tables exist in the source database.

Result Criticality

Review required

Has Fixup

No

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ATPD Autonomous Transaction Processing Dedicated

Scope

SCHEMA

Description

This check indicates that Non-Cloud Objects Storage external tables exist in the source database. These tables are not allowed in Oracle Autonomous Databases.

Effect

Applications relying on user-created external tables will not function as expected.

Action

Consider using the DBMS_CLOUD package to create external tables that use Cloud Object Storage.

19.11.34 has_external_tables_default

The Premigration Advisor Tool check has_external_tables_default indicates that external tables cannot be migrated unless the DIRECTORY objects the tables rely on have been created.

Result Criticality

Action required

Has Fixup

No

Target Cloud

This is a default check. It applies to the following:

• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Scope

SCHEMA

Description

This check indicates that external tables cannot be migrated unless the DIRECTORY objects that the tables rely on have been created already in the target database.

Effect

The schema mode migration of external tables will fail when those tables rely on DIRECTORY objects that don't already exist.

Action

Before migration, create the necessary DIRECTORY objects on the target database, or migrate to the target database using Full mode.

19.11.35 has_external_tables_serverless

The Premigration Advisor Tool check has_external_tables_serverless indicates that there are non-cloud Objects Storage external tables in the source database.

Result Criticality

Review required

Has Fixup

No

Target Cloud

• ADWS Autonomous Data Warehouse Shared
• ATPS Autonomous Transaction Processing Shared

Scope

SCHEMA

Description

Non-Cloud Objects Storage External tables were found. These objects are not allowed in Oracle Autonomous Database.

Effect

Applications relying on user-created external tables will not function as expected. External tables in Oracle Autonomous Database (ADB) must be recreated using Object Storage Service or File Storage Service.

Attempting to create a non-Cloud Object Storage external tables as part of the migration results in those tables being created as non-external tables.

Action

Drop the empty imported table. Use the DBMS_CLOUD package to create External Tables using Cloud Object Storage Service or use File Storage Service. for more info see

19.11.36 has_fmw_registry_in_system

The Premigration Advisor Tool check has_fmw_registry_in_system indicates that the Fusion Middleware Schema Version Registry must be moved out of the SYSTEM schema before migration.

Result Criticality

Action required

Has Fixup

No

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Scope

INSTANCE

Description

The Fusion Middleware Schema Version Registry is in the SYSTEM schema. It must be moved out of the SYSTEM schema before you start the migration.

Effect

If the Fusion Middleware Version Registry is not moved, then after upgrade, vital information regarding what Fusion Middleware applications are installed will be lost.

Action

Before migration, run the Fusion Middleware Upgrade Assistant command ua -moveRegistry.

19.11.37 has_illegal_characters_in_comments

The Premigration Advisor Tool check has_illegal_characters_in_comments indicates that there are characters in table comments that are not legal in the databases character set.

Result Criticality

Review required

Has Fixup

No

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Scope

SCHEMA

Description

This is a default check for characters in TABLE and COLUMN comments as well as PL/SQL sources for characters that are not legal in the databases character set.

Effect

Illegal characters can result in "ORA-39346: data loss in character set conversion for object" errors during import. The illegal characters will be replaced with the default replacement character.

Action

Before migration, delete any illegal characters or replace them with valid characters.

19.11.38 has_ilm_ado_policies

The Premigration Advisor Tool check has_ilm_ado_policies indicates that Information Lifestyle Management (ILM) Automatic Data Optimization Policies (ADO) will not migrate.

Result Criticality

Review required

Has Fixup

No

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Scope

SCHEMA

Description

Tables exist with ILM Automatic Data Optimization Policies. These policies will not migrate to Oracle Autonomous Database.

Effect

Tables with ILM ADO Policies (Release 12c and later) will be created without the ILM ADO Policy in Oracle Autonomous Transaction Processing (ATP) and Oracle Autonomous Data Warehouse (ADW).

Action

No action is required.

19.11.39 has_incompatible_jobs

The Premigration Advisor Tool check has_incompatible_jobs indicates that Information Lifestyle Management (ILM) Automatic Data Optimization Policies (ADO) will not migrate.

Result Criticality

Review required

Has Fixup

No

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Scope

SCHEMA

Description

Scheduler Jobs and Programs other than PLSQL_BLOCK or STORED_PROCEDURE are present on the source, but not supported on Oracle Autonomous Database (ADB).

Effect

Scheduler Jobs and Programs types such as EXECUTABLE and EXTERNAL_SCRIPT will not run on Oracle Autonomous Database.

Action

Databases using unsupported Job or Program types should be modified before migrating to Oracle Autonomous Database. Recreate required Job or Programs using types allowed in ADB

19.11.40 has_index_organized_tables

The Premigration Advisor Tool check has_index_organized_tables indicates that Index Organized tables are present in the source database.

Result Criticality

Review suggested

Has Fixup

No

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Scope

SCHEMA

Description

Index-organized tables are not allowed in Oracle Autonomous Database (ADB). However, attempting to create one does not generate an error. Instead, a heap-organized table with a primary key index is created.

Effect

The recreated tables can perform differently, so you should review them.

Action

Tables in the target database are created as non-index-organized tables (that is, as regular tables).

19.11.41 has_java_objects

The Premigration Advisor Tool check has_java_objects indicates that there are Java objects present in the source database.

Result Criticality

Action required

Has Fixup

Yes

Target Cloud

• ADWS Autonomous Data Warehouse Shared
• ATPS Autonomous Transaction Processing Shared

Scope

SCHEMA

Description

Java objects will not migrate by default.

Effect

When the Java virtual machine (JAVAVM) feature is not enabled on the target system, any applications relying on Java objects will fail after migration.

Action

Non-essential Java Objects should be excluded from the migration process. Enable the JAVAVM feature on the target system, as described in "Using Oracle Java on Autonomous Database" in Oracle Autonomous Database Using Oracle Autonomous Database on Shared Exadata Infrastructure.

19.11.42 has_java_source

The Premigration Advisor Tool check has_java_source indicates that there are Java sources present in the source database.

Result Criticality

Action required

Has Fixup

Yes

Scope

SCHEMA

Target Cloud

• ADWS Autonomous Data Warehouse Shared
• ATPS Autonomous Transaction Processing Shared

Description

Java sources will not migrate by default.

Effect

When the Java virtual machine (JAVAVM) feature is not enabled on the target system, any applications relying on Java objects will fail after migration.

Action

Non-essential Java Objects should be excluded from the migration process. Enable the JAVAVM feature on the target system, as described in "Using Oracle Java on Autonomous Database" in Oracle Autonomous Database Using Oracle Autonomous Database on Shared Exadata Infrastructure

19.11.43 has_libraries

The Premigration Advisor Tool check has_libraries indicates that there are applications that require the CREATE LIBRARY statement.

Result Criticality

Action required

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

The CREATE LIBRARY statement is not allowed on Oracle Autonomous Database.

Effect

Applications that depend on these libraries will fail, because the libraries will not be created on the target instance.

Action

Applications must be updated to remove their dependencies on any listed libraries.

Consider using Functions for business logic previously implemented in external libraries.

19.11.44 has_logging_off_for_partitions

The Premigration Advisor Tool check has_logging_off_for_partitions indicates that there are Partitions using the NOLOGGING storage attribute.

Result Criticality

Review suggested

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

Partitions with the NOLOGGING storage attribute are be changed to LOGGING during migration.

Effect

Partitions created with NOLOGGING will automatically be created in Oracle Autonomous Database as partitions with LOGGING. Check the LOGGING attribute in DBA_TAB_PARTITIONS.

Action

No action required.

19.11.45 has_logging_off_for_subpartitions

The Premigration Advisor Tool check has_logging_off_for_subpartitions indicates that there are Partitions using the NOLOGGING storage attribute.

Result Criticality

Review suggested

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

Subpartitions with the NOLOGGING storage attribute are be changed to LOGGING during migration.

Effect

Subpartitions created with NOLOGGING will automatically be created in Oracle Autonomous Database as subpartitions with LOGGING. Check the LOGGING attribute in DBA_TAB_SUBPARTITIONS.

Action

No action required.

19.11.46 has_logging_off_for_tables

The Premigration Advisor Tool check has_logging_off_for_tables indicates that there are tables using the NOLOGGING storage attribute.

Result Criticality

Review suggested

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

Tables with the NOLOGGING storage attribute are be changed to LOGGING during migration.

Effect

Tables created with NOLOGGING will automatically be created in Oracle Autonomous Database as tables with LOGGING. Check the LOGGING attribute in DBA_TABLES.

Action

No action required.

19.11.47 has_low_streams_pool_size

The Premigration Advisor Tool check has_low_streams_pool_size indicates that Mining Models with unexpected or incorrect attributes are detected.

Result Criticality

Action required

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

Mining models are database schema objects that perform data mining. Mining models with unexpected or incorrect attributes are detected. These mining models will not migrate.

Effect

Mining models with issues will not be exported properly, and cause ORA-39083 errors on import.

Action

Download and apply Patch ID 33270686

19.11.48 has_noexport_object_grants

The Premigration Advisor Tool check has_noexport_object_grants indicates that Oracle Data Pump is unable to export all object grants.

Result Criticality

Review required

Has Fixup

Yes

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

Oracle Data Pump is unable to export all object grants.

Effect

Object grants required for your application may be missing on the target instance, preventing Oracle Data Pump from exporting them to the target instance.

Action

Recreate any required grants on the target instance. See My Oracle Support Document ID 1911151.1 for more information. Note that any SELECT grants on system objects will need to be replaced with READ grants, because SELECT is no longer allowed on system objects.

19.11.49 has_parallel_indexes_enabled

The Premigration Advisor Tool check has_parallel_indexes_enabled indicates that PARALLEL clause indexes exist.

Result Criticality

Review suggested

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

When Parallel DEGREE is specified greater than 1 on INDEX, this setting can result in unexpected behavior after migration.

Effect

When migrating to Oracle Autonomous Database Transaction Processing (ATP), if a PARALLEL clause is specified on the index in your source database, then the clause remains with the index when it is created on the target database, either by using Oracle Data Pump, or by using manual methods. When the PARALLEL degree is greater than 1, this configuration can result in SQL statements running in parallel that are unknown to the end-user.

Action

To specify serial processing, either change the INDEX parallel clause to NOPARALLEL, or alter the PARALLEL degree to 1 before or after the migration.

19.11.50 has_profile_not_default

The Premigration Advisor Tool check has_profile_not_default indicates that schemas exist whose PROFILE is not available on the target system.

Result Criticality

Runtime

Has Fixup

Yes

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

Identifies schemas whose PROFILE is not available on the target system.

Effect

Creation of the schema on the target system fails due to the missing PROFILE.

Action

Either use Oracle Data Pump in FULL mode, or create the needed profiles before migration on the target system, and then use the --analysisprops option with a properties file created by using CPAT with the --gettargetprops option.

19.11.51 has_public_synonyms

The Premigration Advisor Tool check has_public_synonyms indicates that Public Synonyms exist in source system schemas.

Result Criticality

Review required

Has Fixup

No

Scope

SCHEMA_ONLY

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

Identifies schemas whose that contain Public Synonyms. Oracle Data Pump does not migrate Public Synonyms in SCHEMA mode.

Effect

Applications relying on Public Synonyms will not work correctly until the Public Synonyms are recreated on the target instance.

Action

Either use Oracle Data Pump in FULL mode, or recreate the listed relevant objects on the target instance.

19.11.52 has_refs_to_restricted_packages_dedicated

The Premigration Advisor Tool check has_refs_to_restricted_packages_dedicated indicates that there are references to partially or completely unsupported packages.

Result Criticality

Review required

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ATPD Autonomous Transaction Processing Dedicated

Description

Checks for references to packages that are not supported, or that are only partially supported.

Effect

Applications that reference unsupported or restricted use packages can fail.

Action

Applications that reference unsupported packages must be modified before migration to Oracle Autonomous Database Dedicated. Applications referencing partially supported packages require testing and validation to ensure that they only use unrestricted functions and procedures.

19.11.53 has_refs_to_restricted_packages_serverless

The Premigration Advisor Tool check has_refs_to_restricted_packages_serverless indicates that there are references to partially or completely unsupported packages.

Result Criticality

Review required

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWS Autonomous Data Warehouse Shared
• ATPS Autonomous Transaction Processing Shared

Description

Checks for references to packages that are not supported, or that are only partially supported.

Effect

Applications that reference unsupported or restricted use packages can fail.

Action

Applications that reference unsupported packages must be modified before migration to Oracle Autonomous Database Serverless. Applications referencing partially supported packages require testing and validation to ensure that they only use unrestricted functions and procedures.

19.11.54 has_refs_to_user_objects_in_sys

The Premigration Advisor Tool check has_refs_to_user_objects_in_sys indicates that there are user schema objects dependent on SYS or SYSTEM.

Result Criticality

Action required

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

Detects if objects in user schemas depend on user-defined objects in SYS or SYSTEM schemas.

Effect

Migration will fail for schemas that depend on user-defined objects in SYS or SYSTEM.

Action

Oracle recommends that you move user-defined objects in SYS and SYSTEM schemas before migration, and update the references. Consider dropping any user-defined objects that are no longer required.

19.11.55 has_role_privileges

The Premigration Advisor Tool check has_role_privileges indicates that some role privileges used in the source database are not available in the target database

Result Criticality

Action required

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

Detects the presence of role privileges used in the source database that are not available on the target Oracle Autonomous Database.

Effect

After migration, applications can encounter operation failures due to role privilege issues.

Action

Find alternatives for those roles granted in the source database that are not available in the target Oracle Autonomous Database instance. For example, you may want to substitute the PDB_DBA role for some schemas granted the DBA role on the source instance. Similarly, you may want to substitute the DATAPUMP_CLOUD_IMP role on the target instance for schemas granted DATAPUMP_IMP_FULL_DATABASE or IMP_FULL_DATABASE on the source instance. Whether such alternatives are appropriate can only be determined with testing, and by experts familiar with the applications where these role privileges occur.

19.11.56 has_sqlt_objects_adb

The Premigration Advisor Tool check has_sqlt_objects_adb indicates that SQLTXPLAIN objects are detected.

Result Criticality

Review suggested

Has Fixup

No

Scope

UNIVERSAL

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

Detects the presence of SQLTXPLAIN (SQLT) objects, which are not supported on Oracle Autonomous Database.

Effect

Objects related to SQLTXPLAIN will fail on import to Oracle Autonomous Database (ADB), which can cause import errors.

Action

Oracle recommends that administrators migrating a source database to Oracle Autonomous Database apply sqdrop.sql in the installation directory under the SQLTXPLAIN installation to drop all SQLTXPLAIN and SQLTXADMIN objects. See My Oracle Support Document ID 1614107.1 for more information.

19.11.57 has_sqlt_objects_default

The Premigration Advisor Tool check has_sqlt_objects_default indicates that SQLTXPLAIN objects are detected that Oracle Data Pump does not export.

Result Criticality

Review suggested

Has Fixup

No

Scope

UNIVERSAL

Target Cloud

• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

Detects the presence of SQLTXPLAIN (SQLT) objects that are not exported by Oracle Data Pump.

Effect

Some objects related to SQLTXPLAIN will not be imported on the target instance, possibly causing import errors.

Action

Oracle recommends that SQLTXPLAIN users run sqcreate.sql in the target environment after the import is complete. The sqcreate.sql script runs sqdrop.sql, and then reinstalls all required objects. For more information, see My Oracle Support Document ID 1614107.1.

19.11.58 has_sys_privileges

The Premigration Advisor Tool check has_sys_privileges indicates that some system privileges in the source database are not available in the target database.

Result Criticality

Action required

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

Detects that there are some system privileges used in the source database that are not available on the Oracle Autonomous Database.

Effect

Operation failures can occur on the Oracle Autonomous Database, because of system privilege issues.

Action

Verify whether all system privileges will be needed on the Oracle Autonomous Database, and remove the grants for those privileges that are no longer needed. Find alternatives for the granted system privileges that are not available in the target Oracle Autonomous Database (ADB). For example, with schemas in ADB instances, replace GRANT CREATE JOB to USER-WHO-HAD-CREATE-ANY-JOB Whether such alternatives are appropriate can only be determined by experts familiar with the applications in question and with testing.

19.11.59 has_tables_that_fail_with_dblink

The Premigration Advisor Tool check has_tables_that_fail_with_dblink indicates that there are tables with LONG or LONG RAW data types

Result Criticality

Action required

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

Tables with LONG or LONG RAW data types will not migrate over a DBLINK with Oracle Data Pump.

All forms of LONG data types (LONG, LONG RAW, LONG VARCHAR, LONG VARRAW) were deprecated in Oracle8i Release 8.1.6. For succeeding releases, the LONG data type was provided for backward compatibility with existing applications. In new applications developed with later releases, Oracle strongly recommends that you use CLOB and NCLOB data types for large amounts of character data.

Effect

Any applications relying on tables with LONG or LONG RAW data types will fail.

Action

Use Oracle Data Pump without DBLINK, or exclude the schemas and tables that have columns with LONG or LONG RAW data types.

19.11.60 has_tables_with_long_raw_datatype

The Premigration Advisor Tool check has_tables_with_long_raw_datatype indicates that there are tables with LONG or LONG RAW data types

Result Criticality

Action required

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWS Autonomous Data Warehouse Shared

Description

ADWS does not support tables with LONG or LONGRAW data where the table has the Oracle Hybrid Columnar Compression (HCC) compression clause, or where compression is DISABLED.

Effect

Tables with LONG or LONG RAW data types will not migrate.

In Oracle Autonomous Data Warehouse (ADW), tables with LONG or LONG RAW data types are not created when the table has either an HCC compression clause, or compression is DISABLED, which would result with tables being compressed by default with HCC compressed by default on ADW.

All forms of LONG data types (LONG, LONG RAW, LONG VARCHAR, LONG VARRAW) were deprecated in Oracle8i Release 8.1.6. For succeeding releases, the LONG data type was provided for backward compatibility with existing applications. In new applications developed with later releases, Oracle strongly recommends that you use CLOB and NCLOB data types for large amounts of character data.

Action

Oracle recommends that you you create the table manually on ADW with compression enabled.

19.11.61 has_tables_with_xmltype_column

The Premigration Advisor Tool check has_tables_with_xmltype_column indicates that there are tables with XMLTYPE columns.

Result Criticality

Action required

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

Tables with XMLType column will not migrate unless the STORAGE_TYPE setting is BINARY.

Effect

Any applications relying on XMLType columns that are not stored as BINARY will fail.

Action

Tables with XMLType columns defined with CLOB or Object-Relational storage are not supported in Oracle Autonomous Database. When the relevant objects column XMLSCHEMA is not empty, this indicates that your application uses XML Schema Objects, and additional work may be required. For non-schema types, the BINARY storage option must be used. See Oracle Support Document ID 1581065.1 for information about how to convert CLOB columns to BINARY.

19.11.62 has_trusted_server_entries

The Premigration Advisor Tool check has_trusted_server_entries indicates that there areTRUSTED_SERVER entries that cannot be recreated on Oracle Autonomous Database.

Result Criticality

Runtime

Has Fixup

No

Scope

INSTANCE

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

Checks for TRUSTED_SERVER entries. These entries cannot be recreated on Oracle Autonomous Database (ADB).

Effect

The DBMS_DISTRIBUTED_TRUST_ADMIN package is not available on Oracle Autonomous Database (ADB). As a result, any TRUSTED_SERVER entries other than the default (Trusted:All) will not be recreated on the target ADB instance.

Action

To avoid any exceptions reported by Oracle Data Pump during migration from the source database to the target database, specify exclude=trusted_db_link. To control access to your ADB instance, use Oracle Cloud Infrastructure firewall features to control access to your ADB instance.

19.11.63 has_user_defined_objects_in_sys

The Premigration Advisor Tool check has_user_defined_objects_in_sys indicates that there are User-defined objects in the SYS or SYSTEM schemas.

Result Criticality

Action required

Has Fixup

No

Scope

INSTANCE

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

This check indicates that user-defined objects exist in the SYS or SYSTEM schemas

Effect

User-defined objects in the SYS or SYSTEM schemas will not migrate. Any applications relying on user-defined objects in SYS and SYSTEM will fail.

Action

\

Before migration, Oracle recommends that you move out of SYS and SYSTEM any user-defined objects. Update any hardcoded references to those objects. Consider dropping any user-defined objects that are no longer required.

19.11.64 has_users_with_10g_password_version

The Premigration Advisor Tool check has_users_with_10g_password_version indicates that there are user accounts using 10G password version.

Result Criticality

Review required.

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

This check indicates that there are users on the source database that are using the 10G password version. This password version is desupported. After migration, users verified by the 10G password version will not be able to log in.

Effect

After migration, users identified by the 10G password version fail to connect to the database, and receive ORA-1017 errors. During Oracle Data Pump migration ORA-39384 warnings are generated.

Action

To avoid Oracle Data Pump migration warnings, before migration, Oracle recommends that you change the passwords for any users listed as using the 10G password version. Alternatively, you can modify these users' passwords after migration to avoid login failures. See Oracle Support Document ID 2289453.1 for more information.

19.11.65 has_sys_privileges

The Premigration Advisor Tool check has_sys_privileges indicates that some system privileges in the source database are not available in the target database.

Result Criticality

Action required

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

Detects that there are some system privileges used in the source database that are not available on the Oracle Autonomous Database.

Effect

Operation failures can occur on the Oracle Autonomous Database, because of system privilege issues.

Action

Verify whether all system privileges will be needed on the Oracle Autonomous Database, and remove the grants for those privileges that are no longer needed. Find alternatives for the granted system privileges that are not available in the target Oracle Autonomous Database (ADB). For example, with schemas in ADB instances, replace GRANT CREATE JOB to USER-WHO-HAD-CREATE-ANY-JOB Whether such alternatives are appropriate can only be determined by experts familiar with the applications in question and with testing.

19.11.66 has_tables_that_fail_with_dblink

The Premigration Advisor Tool check has_tables_that_fail_with_dblink indicates that there are tables with LONG or LONG RAW data types

Result Criticality

Action required

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

Tables with LONG or LONG RAW data types will not migrate over a DBLINK with Oracle Data Pump.

All forms of LONG data types (LONG, LONG RAW, LONG VARCHAR, LONG VARRAW) were deprecated in Oracle8i Release 8.1.6. For succeeding releases, the LONG data type was provided for backward compatibility with existing applications. In new applications developed with later releases, Oracle strongly recommends that you use CLOB and NCLOB data types for large amounts of character data.

Effect

Any applications relying on tables with LONG or LONG RAW data types will fail.

Action

Use Oracle Data Pump without DBLINK, or exclude the schemas and tables that have columns with LONG or LONG RAW data types.

19.11.67 has_tables_with_long_raw_datatype

The Premigration Advisor Tool check has_tables_with_long_raw_datatype indicates that there are tables with LONG or LONG RAW data types

Result Criticality

Action required

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWS Autonomous Data Warehouse Shared

Description

ADWS does not support tables with LONG or LONGRAW data where the table has the Oracle Hybrid Columnar Compression (HCC) compression clause, or where compression is DISABLED.

Effect

Tables with LONG or LONG RAW data types will not migrate.

In Oracle Autonomous Data Warehouse (ADW), tables with LONG or LONG RAW data types are not created when the table has either an HCC compression clause, or compression is DISABLED, which would result with tables being compressed by default with HCC compressed by default on ADW.

All forms of LONG data types (LONG, LONG RAW, LONG VARCHAR, LONG VARRAW) were deprecated in Oracle8i Release 8.1.6. For succeeding releases, the LONG data type was provided for backward compatibility with existing applications. In new applications developed with later releases, Oracle strongly recommends that you use CLOB and NCLOB data types for large amounts of character data.

Action

Oracle recommends that you you create the table manually on ADW with compression enabled.

19.11.68 has_tables_with_xmltype_column

The Premigration Advisor Tool check has_tables_with_xmltype_column indicates that there are tables with XMLTYPE columns.

Result Criticality

Action required

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

Tables with XMLType column will not migrate unless the STORAGE_TYPE setting is BINARY.

Effect

Any applications relying on XMLType columns that are not stored as BINARY will fail.

Action

Tables with XMLType columns defined with CLOB or Object-Relational storage are not supported in Oracle Autonomous Database. When the relevant objects column XMLSCHEMA is not empty, this indicates that your application uses XML Schema Objects, and additional work may be required. For non-schema types, the BINARY storage option must be used. See Oracle Support Document ID 1581065.1 for information about how to convert CLOB columns to BINARY.

19.11.69 has_trusted_server_entries

The Premigration Advisor Tool check has_trusted_server_entries indicates that there areTRUSTED_SERVER entries that cannot be recreated on Oracle Autonomous Database.

Result Criticality

Runtime

Has Fixup

No

Scope

INSTANCE

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

Checks for TRUSTED_SERVER entries. These entries cannot be recreated on Oracle Autonomous Database (ADB).

Effect

The DBMS_DISTRIBUTED_TRUST_ADMIN package is not available on Oracle Autonomous Database (ADB). As a result, any TRUSTED_SERVER entries other than the default (Trusted:All) will not be recreated on the target ADB instance.

Action

To avoid any exceptions reported by Oracle Data Pump during migration from the source database to the target database, specify exclude=trusted_db_link. To control access to your ADB instance, use Oracle Cloud Infrastructure firewall features to control access to your ADB instance.

19.11.70 has_user_defined_objects_in_sys

The Premigration Advisor Tool check has_user_defined_objects_in_sys indicates that there are User-defined objects in the SYS or SYSTEM schemas.

Result Criticality

Action required

Has Fixup

No

Scope

INSTANCE

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

This check indicates that user-defined objects exist in the SYS or SYSTEM schemas

Effect

User-defined objects in the SYS or SYSTEM schemas will not migrate. Any applications relying on user-defined objects in SYS and SYSTEM will fail.

Action

\

Before migration, Oracle recommends that you move out of SYS and SYSTEM any user-defined objects. Update any hardcoded references to those objects. Consider dropping any user-defined objects that are no longer required.

19.11.71 has_users_with_10g_password_version

The Premigration Advisor Tool check has_users_with_10g_password_version indicates that there are user accounts using 10G password version.

Result Criticality

Review required.

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

This check indicates that there are users on the source database that are using the 10G password version. This password version is desupported. After migration, users verified by the 10G password version will not be able to log in.

Effect

After migration, users identified by the 10G password version fail to connect to the database, and receive ORA-1017 errors. During Oracle Data Pump migration ORA-39384 warnings are generated.

Action

To avoid Oracle Data Pump migration warnings, before migration, Oracle recommends that you change the passwords for any users listed as using the 10G password version. Alternatively, you can modify these users' passwords after migration to avoid login failures. See Oracle Support Document ID 2289453.1 for more information.

19.11.72 has_xmlschema_objects

The Premigration Advisor Tool check has_xmlschema_objects indicates that there are XML Schema Objects in the source database.

Result Criticality

Action required

Has Fixup

No

Scope

UNIVERSAL

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

This check indicates that XML Schema Objects are in the source database. These objects will not migrate.

Effect

XML Schemas are not supported in Oracle Autonomous Database.

Action

Modify your application to not use XML Schema Objects.

19.11.73 has_xmltype_tables

The Premigration Advisor Tool check has_xmltype_tables indicates that there are XMLType tables in the source database.

Result Criticality

Action required

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

This check indicates that there are XMLType Tables in the source database. These tables will not migrate unless the STORAGE_TYPE is BINARY.

Effect

Any applications relying on XMLType tables not stored as BINARY will fail.

Action

XMLType tables with CLOB or Object-Relational storage are not supported in Oracle Autonomous Database. Change the XMLType storage option to BINARY.

19.11.74 modified_db_parameters_dedicated

The Premigration Advisor Tool check modified_db_parameters_dedicated indicates that restricted initialization parameters are modified.

Result Criticality

Review suggested

Has Fixup

No

Scope

INSTANCE

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ATPD Autonomous Transaction Processing Dedicated

Description

This check indicates that there are Oracle Database parameters on the source database instance whose modification is not allowed in Oracle Autonomous Database (Dedicated Infrastructure).

Effect

You are provided with a list of initialization parameters that have been modified in your database, but cannot be modified in Oracle Autonomous Database.

Action

To undersetand what parameters you are permitted to modify, refer to the Oracle Autonomous Database documentation.

19.11.75 modified_db_parameters_serverless

The Premigration Advisor Tool check modified_db_parameters_serverless indicates that restricted initialization parameters are modified.

Result Criticality

Review suggested

Has Fixup

No

Scope

INSTANCE

Target Cloud

This is a default check. It applies to the following:

• ADWS Autonomous Data Warehouse Shared
• ATPS Autonomous Transaction Processing Shared

Description

This check indicates that there are Oracle Database parameters on the source database instance whose modification is not allowed in Oracle Autonomous Database (Shared Infrastructure).

Effect

You are provided with a list of initialization parameters that have been modified in your database, but cannot be modified in Oracle Autonomous Database.

Action

To understand what parameters you are permitted to modify, refer to the Oracle Autonomous Database documentation.

19.11.76 nls_character_set_conversion

The Premigration Advisor Tool check nls_character_set_conversion indicates that there are character codes on the source database that are invalid in Oracle Autonomous Database.

Result Criticality

Runtime

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

This check warns of issues caused by conversion of character data from the source to the target database character set, such as expansion of character values beyond column length or loss of invalid character codes.

Effect

During migration you can encounter ORA-1401 or loss of invalid character codes due to character set conversion from the source to the target database character set.

Action

Correct the issue as needed. Possible solutions include the following:

• Use Database Migration Assistant for Unicode (DMU) to scan the schemas that you want to migrate, and analyze all possible convertibility issues
• Create a new target instance using the same character set as the source instance. See the Oracle Cloud Infrastructure Documentation for information on choosing a character set when creating a database instance.

See the Oracle Cloud Infrastructure documentation for information on choosing a character set when creating a database instance.

Note:

Oracle recommends that you use the default database character set, AL32UTF8

19.11.77 nls_national_character_set

The Premigration Advisor Tool check nls_national_character_set indicates that the NCHAR and NVARCHAR2 lengths are different on the source and target databases.

Result Criticality

Review required

Has Fixup

No

Scope

UNIVERSAL

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

This check indicates that the NCHAR and NVARCHAR2 lengths are different on the source and target databases.

Check for issues caused by the conversion of character data from the source to the target national character set, such as expansion of character values beyond data type limits or loss of invalid character codes.

Effect

During migration you can encounter ORA-01401 or loss of invalid character codes due to character set conversion from the source to the target national character set.

Action

If possible, provision the target database on Oracle Cloud Infrastructure with the same national character set as the source database, and enable extended data types in the target cloud database. See the Oracle Cloud Infrastructure documentation for information on choosing a national character set when creating a database instance.

19.11.78 nls_nchar_ora_910

The Premigration Advisor Tool check nls_nchar_ora_910 indicates that the NCHAR and NVARCHAR2 lengths are greater than the maximum length on the target databases.

Result Criticality

Action required

Has Fixup

No

Scope

SCHEMA

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

This check indicates that the NCHAR and NVARCHAR2 lengths are greater than the maximum permitted length on the target database.

Determine the maximum column length for the national database character set on the target database, and check for NCHAR and NVARCHAR2 columns on the source database whose character length exceeds the limit on the target database.

Effect

During migration you can encounter ORA-00910 errors due to the difference of the maximum character length of NCHAR and NVARCHAR2 columns between the source and the target database.

Action

If possible, provision the target database on Oracle Cloud Infrastructure with the same national character set as the source database, and enable extended data types in the target cloud database. See the Oracle Cloud Infrastructure documentation for information on choosing a national character set when creating a database instance.

19.11.79 options_in_use_not_available_dedicated

The Premigration Advisor Tool check options_in_use_not_available_dedicated indicates that unavailable database options are present on the source database.

Result Criticality

Review suggested

Has Fixup

No

Scope

INSTANCE

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ATPD Autonomous Transaction Processing Dedicated

Description

Generates a list of database options that are in use on the source, but not available in Oracle Autonomous Database (Dedicated Infrastructure).

Effect

If the database that you are migrating has applications or schemas in your database that use options that are not available on Oracle Autonomous Database, then it is possible that these applications will not work after migration.

Action

Verify that the applications or schemas in your source database depend on the options that are not supported on Oracle Autonomous Database (Dedicated Infrastructure), and plan accordingly.

19.11.80 options_in_use_not_available_serverless

The Premigration Advisor Tool check options_in_use_not_available_serverless indicates that unavailable database options are present on the source database.

Result Criticality

Review suggested

Has Fixup

No

Scope

INSTANCE

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ATPD Autonomous Transaction Processing Dedicated

Description

Generates a list of database options that are in use on the source, but not available in Oracle Autonomous Database (Shared Infrastructure).

Effect

If the database that you are migrating has applications or schemas in your database that use options that are not available on Oracle Autonomous Database, then it is possible that these applications will not work after migration.

Action

Verify that the applications or schemas in your source database depend on the options that are not supported on Oracle Autonomous Database (Shared Infrastructure), and plan accordingly.

19.11.81 standard_traditional_audit_adb

The Premigration Advisor Tool check standard_traditional_audit_adb indicates that Traditional Audit configurations are detected in the database.

Result Criticality

Review suggested

Has Fixup

No

Scope

INSTANCE

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

Traditional audit, which was deprecated in Oracle Database 21c, is desupported starting with Oracle Database 23c. Traditional Audit configurations have been detected in this database.

Effect

Traditional Auditing is desupported in Oracle Database 23c. Oracle strongly recommends that you start using Unified Auditing.

Action

Delete the Traditional Auditing configurations. To assist you, use the instructions in Oracle Support Document ID 2909718.1.

19.11.82 standard_traditional_audit_default

The Premigration Advisor Tool check standard_traditional_audit_default indicates that Traditional Audit configurations are detected in the database.

Result Criticality

Review suggested

Has Fixup

No

Scope

INSTANCE

Target Cloud

• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

Traditional audit, which was deprecated in Oracle Database 21c, is desupported starting with Oracle Database 23c. Traditional Audit configurations have been detected in this database.

Effect

Traditional Auditing is desupported in Oracle Database 23c. Oracle strongly recommends that you start using Unified Auditing.

Action

Delete the traditional auditing configurations using the instructions found in Oracle Support Document ID 2909718.1. Ensure that the following init.ora parameter values are set in CDB$ROOT, and restart the database:

AUDIT_TRAIL=none 
AUDIT_SYS_OPERATIONS=false

19.11.83 timezone_table_compatibility_higher_dedicated

The Premigration Advisor Tool check timezone_table_compatibility_higher_dedicated indicates that the timezone setting is a more recent version on the source than on the target database.

Result Criticality

Runtime

Has Fixup

No

Scope

UNIVERSAL

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ATPD Autonomous Transaction Processing Dedicated

Description

The source database TZ_VERSION cannot be higher than the target TZ_VERSION.

Effect

Migration is not possible until the target TZ_VERSION is the same or higher than the source database TZ_VERSION.

Action

Use the "Enable time-zone update" option of the Schedule maintenance dialog for the Quarterly Maintenance Update to update the time zone version on your target instance.

19.11.84 timezone_table_compatibility_higher_default

The Premigration Advisor Tool check timezone_table_compatibility_higher_default indicates that the timezone setting is a more recent version on the source than on the target database.

Result Criticality

Runtime

Has Fixup

No

Scope

UNIVERSAL

Target Cloud

• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

The source database TZ_VERSION cannot be higher than the target TZ_VERSION.

Effect

Migration is not possible until the target TZ_VERSION is the same or higher than the source database TZ_VERSION.

Action

Ensure the target instance has a time zone version equal or greater than the source instance by downloading and installing an appropriate patch from Oracle Support Document ID 412160.1

19.11.85 timezone_table_compatibility_higher_serverless

The Premigration Advisor Tool check timezone_table_compatibility_higher_serverless indicates that the timezone setting is a more recent version on the source than on the target database.

Result Criticality

Runtime

Has Fixup

No

Scope

UNIVERSAL

Target Cloud

• ADWS Autonomous Data Warehouse Shared
• ATPS Autonomous Transaction Processing Shared

Description

The source database TZ_VERSION cannot be higher than the target TZ_VERSION.

Effect

Migration is not possible until the target TZ_VERSION is the same or higher than the source database TZ_VERSION.

Action

Update the Time Zone File Version. Refer to "Manage Time Zone File Version on Autonomous Database"

19.11.86 unified_and_standard_traditional_audit_adb

The Premigration Advisor Tool check unified_and_standard_traditional_audit_adb indicates that Traditional Audit configurations are detected in the database.

Result Criticality

Runtime

Has Fixup

No

Scope

INSTANCE

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared

Description

Traditional audit, which was deprecated in Oracle Database 21c, is desupported starting with Oracle Database 23c. Traditional Audit configurations have been detected in this database, which is configured to use only Unified Auditing.

Effect

Performance can degrade unless the traditional audit configurations in the database are deleted.

Action

Oracle strongly recommends that you delete the Traditional Auditing configurations

19.11.87 unified_and_standard_traditional_audit_default

The Premigration Advisor Tool check unified_and_standard_traditional_audit_default indicates that Traditional Audit configurations are detected in the database.

Result Criticality

Runtime

Has Fixup

No

Scope

INSTANCE

Target Cloud

• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

Traditional audit, which was deprecated in Oracle Database 21c, is desupported starting with Oracle Database 23c. Traditional Audit configurations have been detected in this database, which is configured to use only Unified Auditing..

Effect

Performance can degrade unless the traditional audit configurations in the database are deleted.

Action

Delete the traditional auditing configurations using the instructions found in Oracle Support Document ID 2909718.1. Ensure that the following init.ora parameter values are set in CDB$ROOT, and restart the database:

AUDIT_TRAIL=none 
AUDIT_SYS_OPERATIONS=false

19.11.88 xdb_resource_view_has_entries Check

The Premigration Advisor Tool check xdb_resource_view_has_entries Check indicates that there is an XDB Repository that is not supported in Oracle Autonomous Database. Entries in RESOURCE_VIEW will not migrate.

Result Criticality

Review required

Has Fixup

No

Target Cloud

• ADWD Autonomous Data Warehouse Dedicated
• ADWS Autonomous Data Warehouse Shared
• ATPD Autonomous Transaction Processing Dedicated
• ATPS Autonomous Transaction Processing Shared
• Default (an Oracle Database instance that is not Oracle Autonomous Database)

Description

This check applies to source schema for Oracle Data Pump and Oracle GoldenGate migrations, and Oracle Data Pump database links. When there is an Oracle XML DB repository (XDB Repository) that is not supported in Oracle Autonomous Database (ADB), entries in RESOURCE_VIEW will not migrate.

Effect

Applications relying on entries in the XDB Repository RESOURCE_VIEW may not function as expected.

Action

Applications must be updated to remove their dependencies on the XDB Repository. For more information on determining if XDB is being used in your database see Oracle Support Document ID 733667.1