Migration Requests are unordered lists of Migration Plans that are to be migrated together. Algorithms, SQL statements, or specific keys are used to specify the set of objects you want to export. When complete, the request describes the complete data set that is extracted to the migration export file when the request is executed.
To view or define a migration request, navigate using
.Use the Migration Request Query portal to search for an existing migration request. Once a migration plan is selected, you are brought to the maintenance portal to view and maintain the selected record.
Define one or more Migration Plans for the migration request. Note that the order doesn’t matter. During the export process, CMA looks at all objects that qualify for the export and will group them together based on their relationships.
For each option, define an appropriate Selection Type, which is used to filter which records in the migration plan’s object should be selected. The valid values are Algorithm, SQL Statement, and Specific Key.
For the option Algorithm, specify an Algorithm for the Key Selection. The algorithm is responsible for returning a list of key values to include in the migration.
For the option SQL Statement, specify an SQL Statement for the key selection. may be used to limit the keys to include. To migrate all records in the table, the SQL statement "1=1" may be used. Refer to the inline help for other examples.
For the option Specific Key, enter one or more primary keys to individually to define the records to include. Click the “+” to enter each additional key. Each row represents one key and supports a multi-part primary key.
Where Used
Follow this link to open the data dictionary where you can view the tables that reference F1_MIGR_REQ.
Copyright © 2007, 2016, Oracle and/or its affiliates. All rights reserved. Documentation build: 2.5.2016 10:21:45 [T1_1454696505000]