Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Multi-tenant database : Tenant Data Recovery : Move multiple tables and sequences with the DATAMOVE user interface : Move table data by group
 
Move table data by group
When you select Option 3 of Tenant/Group Data Move, you can move data from multiple tables for one group.
Use the following steps to move data by group:
1. From the main menu, choose 3.
The following screen appears:
Please Choose a Group
-----------------------------------------------------------------------
Option| Group Name | ID | Description
-----------------------------------------------------------------------
1|NEregion                        |    -1|
2|SEregion                        |    -2|
3|SWregion                        |    -3|
4|NWregion                        |    -4|
-----------------------------------------------------------------------
(Page 1 of 1)
-----------------------------------------------------------------------
Input Your Choice
(c/C) - Change Display
(q/Q) - Quit (g/G) - Go
2. Choose a group by entering a number and pressing return.
For example, if you enter 3, to select the tenant named SWregion, and an asterisk appears next to your choice:
Please Choose a Group
-----------------------------------------------------------------------
Option| Group Name | ID | Description
-----------------------------------------------------------------------
1|NEregion                        |    -1|
2|SEregion                        |    -2|
*    3|SWregion                        |    -3|
4|NWregion                        |    -4|
-----------------------------------------------------------------------
(Page 1 of 1)
-----------------------------------------------------------------------
Input Your Choice
(c/C) - Change Display
(q/Q) - Quit (g/G) - Go
Note: To undo any selection, select the item a second time.
3. Once you have selected your group, enter g or G for go.
The following menu appears for you to choose a table or tables:
Choose Tables for Data Move
-----------------------------------------------------------------------
Option| Table Name | Table Owner |Number
-----------------------------------------------------------------------
     1|Employee                     |PUB                         |   12
     2|Invoice                      |PUB                         |   13
-----------------------------------------------------------------------
Page 1 of 1
Input Your Choice
(c/C) - Change Display
(a/A) - All (q/Q) - Quit (g/G) - Go
4. Select the table or tables you want to move data for by entering the number from the Option column.
For each table you select, an asterisk appears. For example, after choosing option 1, the menu appears as follows:
Choose Tables for Data Move
-----------------------------------------------------------------------
Option| Table Name | Table Owner |Number
-----------------------------------------------------------------------
*    1|Employee                     |PUB                         |   12
     2|Invoice                      |PUB                         |   13
-----------------------------------------------------------------------
Page 1 of 1
Input Your Choice
(c/C) - Change Display
(a/A) - All (q/Q) - Quit (g/G) - Go
5. Enter g or G for go, and begin the data move. DATAMOVE provides status updates during the moving of data.
Note: To cancel the move, enter CTRL-C.