Compress database with ACO
Hi all,
In the coming soon weeks, we will want migrate from 10.2.0.5 to 11.2.0.3. We take the ACO license and we want apply compression to DWH database (aprox 4TB).
I tested this funcionality in a test enviroment with 2 tests:
1) IMPDP with direct path option. As you can imagine, the import is slowly. but I reduce about 20% of disk space. <<<---- WORK WELL
2) Execute an ALTER MOVE in two phases:
a) For non partitioned tables and after that rebuild non partitioned indexes
b) For partitioned tables and after that rebuild partitioned indexes
We need a minimal down time because, this database is in producction enviroment but when I try to compress or rebuild partitioned indexes, I got the following errors:
SYS@ORA11GR2> alter index PPP.PK_DIAL rebuild partition DIAL_110901 compress;
alter index PPP.PK_DIAL rebuild partition DIAL_110901 compress
*
ERROR at line 1:
ORA-28659: COMPRESS must be specified at object level first
SYS@ORA11GR2> alter index PPP.PK_DIAL rebuild;
alter index PPP.PK_DIAL rebuild
*
ERROR at line 1:
ORA-14086: a partitioned index may not be rebuilt as a whole
We have several huge partitioned indexes, and I saw in metalink the next note: *Rebuild a partitioned index specifying compression raises Ora-28659 [ID 312843.1]* and I understand that I need drop and recreate all indexes.
My questions are:
1) We will use COMPRESS option at tablespace level. are there any recommendations about that? for example...use this option at partition or table level
2) which is the recommended method by us, since I have no clear, the reduction of time between the two methods previous.
Thanks a lot
Regards.
Edited by: 927890 on 16-abr-2012 7:48