| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Index Organized Table -- ORA-25182
I'm trying to create an index-organized table. The table will have
two columns, which form a composite PK.
The statement looks like this:
create table holdings_static
(memberid number(10) not null,
symbol varchar2(10) not null,
constraint holdings_static_pk
primary key (memberid, symbol))
organization index tablespace wss_data
storage (initial 64m next 64m);
When I try to run this, I get the following Oracle error:
ORA-25182: feature not currently available for index-organized tables
So I looked this up in the docs, and it says:
Cause: An attempt was made to use one or more of the following feature(s) not currently supported for index-organized tables:
CREATE TABLE with LOB/BFILE/VARRAY columns partitioning/PARALLEL/CREATE TABLE AS SELECT options ALTER TABLE with ADD/MODIFY column options, CREATE INDEX
Action: Do not use the disallowed feature(s) in this release.
I'm using 8.0.6.0.0, my compatible parameter is set to 8.0.5.1.0 ...
The columns involved, as you can see, are simply NUMBER and VARCHAR2, no parallel, no CTAS.
Any ideas???
Chris
 |
 |