Re: Index Organized Table -- ORA-25182

Might be a bug;
I cut your text,
changed 64M to 64K
changed the tablespace name
and ran it under 8.0.5
Table created.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Chris Hamilton wrote in message ...
>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
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Christopher Hamilton
>Oracle DBA -- Sandbox.com
>chamilton_at_sandbox-inc.com
>http://www.sandbox.com/
Received on Fri Oct 15 1999 - 13:33:56 CDT