We are migrating databases from oracel 10g to 11g and we are using advance compression, i have few question please help me to understand
1. if i enable compression on tables is index also get compressed if not how i can enable compression on indexes
2.For table compression i will take the DDL of tables from oracle 10g databases and i create the tables in oracle 11g with COMPRESS FOR ALL OPERATIONS is this the right approach
Appreciated the inputs
1. No , Indexes will have to be rebuild when ever tables are compressed. Specify compress for indexes when you rebuild.
2. No, COMPRESS FOR ALL OPERATIONS (Same as COMPRESS FOR OLTP) requires additional licensing. You have to use COMPRESS which defaults to 10g.
Thanks for the input my scenerio is we are migrating to oracle 11g from 10g and we have licence for the 11g advanced compression
so to implement this feature : from 10g databases i will take only ddl statements belongs to all tables and create the tables with COMPRESS FOR ALL OPERATIONS in 11g database and import the table data in to oracle 11g with table_exists_action=truncate so here both tables and indexes are compressed and i eanbled the advanced compression in 11g is iam correct ?