Home » RDBMS Server » Server Administration » 12c Advanced Row Compression - IOT (12c RAC)
12c Advanced Row Compression - IOT [message #648693] Tue, 01 March 2016 03:22 Go to next message
zaff
Messages: 50
Registered: July 2008
Member
Hi,
Is it possible to use Advanced Row Compression on an Index Organised Table?

Thanks in advance,
Zaf
Re: 12c Advanced Row Compression - IOT [message #648696 is a reply to message #648693] Tue, 01 March 2016 04:03 Go to previous messageGo to next message
John Watson
Messages: 7212
Registered: January 2010
Location: Global Village
Senior Member
You try a few experiments. For example,
orclz> create table iot (c1 number,c2 date,primary key (c1,c2)) organization index compress advanced low;
create table iot (c1 number,c2 date,primary key (c1,c2)) organization index compress advanced low
                                                                                     *
ERROR at line 1:
ORA-00922: missing or invalid option


orclz> create table iot (c1 number,c2 date,primary key (c1,c2)) organization index compress;

Table created.

orclz>

Re: 12c Advanced Row Compression - IOT [message #648702 is a reply to message #648696] Tue, 01 March 2016 05:29 Go to previous messageGo to next message
zaff
Messages: 50
Registered: July 2008
Member
Thanks, John.
How about existing tables? I've tried the following for Advanced Row Compression:

ALTER TABLE MY_IOT_TABLE MOVE ROW STORE COMPRESS ADVANCED;

ALTER TABLE MY_IOT_TABLE MOVE ROW STORE COMPRESS ADVANCED
                   *
ERROR at line 1:
ORA-02158: invalid CREATE INDEX option


Also, is "...organization index compress" the same as Advanced Row Compression?

Regards,
Zaf
Re: 12c Advanced Row Compression - IOT [message #648703 is a reply to message #648702] Tue, 01 March 2016 05:51 Go to previous messageGo to next message
John Watson
Messages: 7212
Registered: January 2010
Location: Global Village
Senior Member
Quote:
Also, is "...organization index compress" the same as Advanced Row Compression?

No.

If you look in the Administrator's Guide chapter 21, you will find a full description. Including this,

Note:
Advanced index compression is not supported for bitmap indexes or index-organized tables.
Advanced index compression cannot be specified on a single column unique index.
Re: 12c Advanced Row Compression - IOT [message #648704 is a reply to message #648703] Tue, 01 March 2016 06:04 Go to previous message
zaff
Messages: 50
Registered: July 2008
Member
ok, thanks for the confirmation.

Regards,
Zabair
Previous Topic: PARALLELISM - Processor
Next Topic: Sysaux tablespace full
Goto Forum:
  


Current Time: Thu Jan 18 00:57:51 CST 2018

Total time taken to generate the page: 0.01378 seconds