The records_per_block_clause lets you specify whether Oracle Database
restricts the number of records that can be stored in a block. This clause ensures that
any bitmap indexes subsequently created on the table will be as compressed as
possible.
Restrictions on Records in a Block
■ You cannot specify either MINIMIZE or NOMINIMIZE if a bitmap index has
already been defined on table. You must first drop the bitmap index.
■ You cannot specify this clause for an index-organized table or a nested table.

MINIMIZE
Specify MINIMIZE to instruct Oracle Database to calculate the largest
number of records in any block in the table and to limit future inserts so that no block
can contain more than that number of records.
Oracle recommends that a representative set of data already exist in the table before
you specify MINIMIZE. If you are using table compression then a representative set of
compressed data should already exist in the table.
Restriction on MINIMIZE : You cannot specify MINIMIZE for an empty table.
NOMINIMIZE Specify NOMINIMIZE to disable the MINIMIZE feature. This is the
default.

[@more@]

ITPub博客

alter table MINIMIZE | NOMINIMIZE records_per_block_clause

最新文章