create table

A new option for load. The table you create with this option is available only to BCP IN and 'alter table unpartition' operations. For example:

  1. Create a table, called TAB:

    create table TAB (col1 int, col2 int, col3 char(50))
    partitioned by roundrobin 3 for load
    

    TAB is unavailable to any user activities until it is unpartitioned.

  2. Load the data into TAB, using BCP IN.

  3. Unpartition TAB.TAB is now available for any user activities.