8.1.4 Reloading to a table

Organization of this subsection
(1) What is reloading to a table?
(2) Migrating data into another table
(3) Modifying table partitioning conditions
(4) Reloading to a table with LOB columns or abstract data type columns provided by a plug-in (LOB attribute)
(5) Using a utility special unit
(6) Reloading with the synchronization point specification

(1) What is reloading to a table?

Table reorganization involves saving table data into a file and then storing the data from the file back into the table. The process for storing data from a file back into a table is called reloading a table.

You can reload a table in units of tables or RDAREAs (applicable to row-partitioned tables).

Figure 8-9 shows an overview of reloading a table.

Figure 8-9 Overview of reloading a table

[Figure]

(2) Migrating data into another table

For details about how to migrate data into another table, see Section 8.1.3 Unloading a table.

(3) Modifying table partitioning conditions

For details about how to modify table partitioning conditions, see Section 8.1.3 Unloading a table.

(4) Reloading to a table with LOB columns or abstract data type columns provided by a plug-in (LOB attribute)

As with table reorganization, you can reload to a LOB column structure base table and LOB columns at the same time or separately.

(5) Using a utility special unit

For details about how to use a utility special unit, see Section 8.1.2 Reorganizing a table.

(6) Reloading with the synchronization point specification

For details about how to reload with the synchronization point specification, see Section 8.1.2 Reorganizing a table.