Use alter table . . . immediate_allocation to explicitly materialize a deferred table. The syntax is:
alter table table_name immediate_allocation
Once you materialize the table, Adaptive Server allocates pages for all data and index partitions.
For example, to materialize the table im_not_here_yet, enter:
alter table im_not_here_yet immediate allocation
