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.
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 |