Bulk Copying Requirements
To perform a bulk copy when loading data from a file into a table, the table must have the following characteristics:
• The table is not journaled.
• The table has no secondary indexes.
• The table is either a heap table (the data from the file is appended to the end of the heap table) or empty and less than 18 pages in size if the table is hash, B-tree, or ISAM (the table is rebuilt with the new data from the file).
If these requirements are not met, the copy is performed in incremental mode.