Executor: HiRDB administrator, DBA privilege holder, and table owner

Data can be moved to another table by executing the pdrorg or pdload command.

The following figure shows how to move data to another table.

Figure 13-92 How to move data to another table

Important

• After data migration, execute the optimizing information collection utility (pdgetcst command) for the migration destination table if necessary. For details about whether execution of the optimizing information collection utility is required, see the manual HiRDB Version 9 Command Reference.
• If you wish to migrate to another HiRDB system a table that has columns of the abstract data type, you must apply the constructor parameter reverse generation function when you use the database reorganization utility (pdrorg command) to unload data of the abstract data type.

Organization of this section

13.16.1 Example 1: Migrating data to another table

13.16.2 Example 2: Migrating data containing XML-type columns by table

13.16.3 Specification examples of column structure information files