|
Re: 12c Advanced Row Compression - IOT [message #648696 is a reply to message #648693] |
Tue, 01 March 2016 04:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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.
|
|
|
|