Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index-Organized Tables Bug Found!!!
This may just be a typo in your report, but you have
insert .... AS select ....
This is just a syntax error though, not a good reason for 00600
--
Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>Well I found a bug in Oracle 8.1.5 on Digital Unix. When I try to
>create an index-organized table as follows:
>
>CREATE TABLE EMP_IOT
> ( EMPNO NUMBER(4) NOT NULL,
> ENAME VARCHAR2(10),
> JOB VARCHAR2(9),
> MGR NUMBER(4),
> HIREDATE DATE,
> SAL NUMBER(7,2),
> COMM NUMBER(7,2),
> DEPTNO NUMBER(2),
> EMP_TYPE NUMBER,
> CONSTRAINT EMP_IOT_PK PRIMARY KEY (EMPNO)
> )
>ORGANIZATION INDEX TABLESPACE JCI_DATA
>PCTTHRESHOLD 20 OVERFLOW TABLESPACE JCI_DATA;
>
>INSERT INTO EMP_IOT AS SELECT * FROM EMP; <**** ORA-600
>
>The insert as select causes an ORA-600 error.
>
>I have been able to create the table be doing a create table as select.
>I have sent this to Oracle, but have not gotten a TAR# back yet
Received on Fri Jul 02 1999 - 13:52:59 CDT