Notifications

23 views

Description

Before adding data preservers or exclude records on the source instance, please review this checklist that summarizes the preflight checks that are performed by the system and that can prevent a clone from completing.

E.G., this clone was canceled because a database view was added to the list of data preservers:

Release or Environment

London, Madrid, New York

Cause

Before adding data preservers or exclude records on the source instance, please review this checklist that summarizes the preflight checks that are performed by the system, and that can prevent a clone from completing.

 Don't create a data preserver on this table

 Why

sys_counter_numberduplicate numbers would result
sys_attachmentthe large table size in the target can cause a failure
pa_favoritesnot supported
any database view 

A database view is a virtual table that is built in real time when the table is displayed. The records don't exist in the system as a physical table.


Examples of common out-of-box database views that cannot be specified in a data preserver list:

incident_metric
problem_metric
incident_sla
wf_activity_context

____


In addition, these are rare database configuration issues that can prevent a clone from succeeding:

A table name that is in upper case must first be changed to lower case.

A schema mismatch error can occur if the COLUMN_TYPE of a table has been changed on the source or target instance within a few days of the clone, e.g., from "varchar(40)" to "mediumtext".

____

Please see this link for 'exclude table' constraints, which explains that the clone will fail during the clone Preflight check if the sys_user or sys_user_has_role tables are added to the clone exclude list. If the sys_properties table is added to the clone exclude list, the clone will complete but the target instance's configuration and UI properties will be incorrect.

KB0712483 - Tables that should not be added to the Clone exclude list.

Resolution

Before adding a data preserver or exclude table, review the checklist above to ensure that the preflight checks will run smoothly and your clone will complete.

Article Information

Last Updated:2019-11-26 00:03:06
Published:2019-11-26