Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index-Organized Tables Bug Found!!!
In article <930941891.11317.0.nnrp-14.9e984b29_at_news.demon.co.uk>,
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> 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
>
>
You are correct about the typo. I did not save the script that I used originally, so I just re-typed it in this posting. It was syntactically correct and did cause the ORA-600 table.
--
Erik
Consultant
Saraswati Systems Corporation - (SSC)
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Fri Jul 02 1999 - 15:33:25 CDT