Move table data by tenant

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 tenant

When you select Option 1 of Tenant/Group Data Move, you can move data from multiple tables for one tenant.

Use the following steps to move data by tenant:

1. From the main menu, choose 1.

The following screen appears:

                Please Choose a Tenant
-----------------------------------------------------------------------
Option|       Tenant Name       |  ID  |       Description
-----------------------------------------------------------------------
     1|Default                  |     0|Default Tenant
     2|store1                   |     1|
     3|store2                   |     2|
     4|store3                   |     3|
     5|store4                   |     8|
     6|store5                   |     9|
     7|allocdis                 |     4|
     8|delayalloc               |     7|
     9|noalloc                  |     5|
    10|noallocdis               |     6|
-----------------------------------------------------------------------
(Page 1 of 1)
-----------------------------------------------------------------------
Input Your Choice
(c/C) - Change Display
(q/Q) - Quit (g/G) - Go

Note: Observe that tenants that have delayed allocation or no allocation are included in the list.

2. Choose a Tenant by entering a number and pressing return.

For example, if you enter 3, to select the tenant named store2, and an asterisk appears next to your choice:

                Please Choose a Tenant
-----------------------------------------------------------------------
Option|       Tenant Name       |  ID  |       Description
-----------------------------------------------------------------------
     1|Default                  |     0|Default Tenant
     2|store1                   |     1|
*    3|store2                   |     2|
     4|store3                   |     3|
     5|store4                   |     8|
     6|store5                   |     9|
     7|allocdis                 |     4|
     8|delayalloc               |     7|
     9|noalloc                  |     5|
    10|noallocdis               |     6|
-----------------------------------------------------------------------
(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 tenant, 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|Customer                     |PUB                       |   10
     2|Employee                     |PUB                       |   12
     3|Invoice                      |PUB                       |   14
     4|Stock                        |PUB                       |   16
     5|Vendor                       |PUB                       |   18
-----------------------------------------------------------------------
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 options 1, 3, and 5, the menu appears as follows:

                Choose Tables for Data Move
-----------------------------------------------------------------------
Option|          Table Name         |     Table Owner          |Number
-----------------------------------------------------------------------
*    1|Customer                     |PUB                       |   10
     2|Employee                     |PUB                       |   12
*    3|Invoice                      |PUB                       |   14
     4|Stock                        |PUB                       |   16
*    5|Vendor                       |PUB                       |   18
-----------------------------------------------------------------------
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.