Cause
The first time a table is altered to include compression, it cannot have a usable bitmap index (partition). Subsequent alter table statements involving compression do not have this same restriction.
The first time a table is altered to include compression, it cannot have a usable bitmap index (partition). Subsequent alter table statements involving compression do not have this same restriction.
If records_per_block has been minimized for one of the tables, but not the other, either perform alter table with the NOMINIMIZE RECORDS_PER_BLOCK option for both tables, or perform alter table with the MINIMIZE RECORDS_PER_BLOCK for both tables. If the hakan factors do not match perform alter table with the NOMINIMIZE RECORDS_PER_BLOCK option for both tables.
Try the following links for this error:
http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm
https://community.oracle.com/message/3777259
https://community.oracle.com/message/6495209
https://community.oracle.com/message/2100311
https://community.oracle.com/message/1946579
https://community.oracle.com/message/10985719
https://community.oracle.com/message/4163447
https://community.oracle.com/message/1444681
Browse all solutions to database errors from Oracle, MS SQL, or MySQL