Comparison of the objects that are migrated

When you migrate objects, more objects than those that you selected might be migrated. The other objects that are also migrated depends on the migration method that you use.
Objects can have dependent objects, required objects, and impacted objects:
Dependent object
An object that needs another object to exist. For example, columns, indexes, and primary keys are dependent objects because they all need a table to exist.
Required object
An object that must exist for a dependent object to exist. For example, if Table A is in Schema A, then Schema A is a required object for Table A.
Impacted object
An object that is affected if another object is changed or dropped. For example, if View A references Table A, the view might be impacted by changes that are made to Table A.

When you migrate selected objects, the required objects and dependent objects for the objects might also be migrated. The additional objects that are migrated depends on the method that you use to migrate the objects: copy and paste, drag and drop, or the comparison method.

The following table shows which objects are included in the migration for each of the migration methods. When you use the copy and paste method, the objects that are migrated depends on the whether you select to copy required objects. You can select to copy required objects only when you are copying schemas or tables and pasting them onto a database object.

Table 1. Objects that are migrated in addition to the selected objects
Selected object type Drag and drop method and comparison method Copy and paste to a database with copy required objects selected Copy and paste without copy required object selected
Schema The schema and its dependent objects, including tables, views, functions, stored procedures, and so on The schema and its dependent objects, including tables, views, functions, stored procedures, and so on The schema
Table The table and its required objects, including an immediate parent table, the table space, and the buffer pool The table and its required objects, including an immediate parent table, the table space, and the buffer pool The table
View The view, the required schema, and the required referenced objects, such as views, tables, and aliases The view, the required schema, and the required referenced objects, such as views, tables, and aliases The view
Alias The alias, the required schema, and the object on which the alias is defined The alias, the required schema, and the object on which the alias is defined The alias
Materialized query table The materialized query table and its required objects, including all the tables The materialized query table and its required objects, including all the tables The materialized query table
Stored procedure The stored procedure Not applicable The stored procedure
Function The function Not applicable The function
Sequence The sequence Not applicable The sequence
Table space The table space and its buffer pool Not applicable The table space
Buffer pool The buffer pool Not applicable The buffer pool

Feedback