You use the xtrepO command to extract data from an ORACLE database. You can extract selected data only by specifying in the xtrepO command the name of the table to be extracted and the extraction method.

HiRDB Dataextractor imports extracted data into the target table by establishing correspondence between columns sequentially from left to right. If the formats (number of columns and the order of the columns) do not match between the extraction-system table and the import-system table, you must use the xtrepO command to extract data on the basis of the format of the table on the target system.

HiRDB Dataextractor can do the following:

• Extract data in units of tables
• Select and sort columns to be extracted
• Select and sort rows to be extracted
• Select the default null value

Organization of this subsection

(1) Extracting data in units of tables

(2) Selecting and sorting columns to be extracted

(3) Selecting and sorting rows to be extracted

(4) Selecting default null values