Data Movement Utilities Guide and Reference

Restrictions and Limitations

The following restrictions apply to the import utility:

• This utility does not support the use of nicknames.
• If the existing table is a parent table containing a primary key that is referenced by a foreign key in a dependent table, its data cannot be replaced, only appended to.
• You cannot perform an import replace operation into an underlying table of a summary table defined in refresh immediate mode.
• You cannot import data into a system table, a summary table, or a table with a structured type column.
• You cannot import data into declared temporary tables.
• Views cannot be created through the import utility.
• Referential constraints and foreign key definitions are not preserved when creating tables from PC/IXF files. (Primary key definitions are preserved if the data was previously exported using SELECT *.)
• Because the import utility generates its own SQL statements, the maximum statement size of 64KB may, in some cases, be exceeded.

The following limitation applies to the import utility:

If the volumn of output messages generated by an import operation against a remote database exceeds 60KB, the utility will keep the first 30KB and the last 30KB.