Re: INSERT INTO TEMPORARY TABLE CAUSES ORA-600 2656 WITH TEMPORARY TABLESPACES

martin wrote:

> Please let me know how to solve this oracle bug:
>
> FIRST INSERT INTO TEMPORARY TABLE CAUSES ORA-600 2656 WITH TEMPORARY
> TABLESPACES
>
> Product Oracle Server - Enterprise Edition V7 Product Version 8.1.4
> Platform Intel Windows NT Platform Version 4.0
> Database Version 8.1.4
>
> Thank you.
> martin

You can not have tables you insert into in a temporary tablespace if it is a temporary tablespace.

But an ORA-00600 is an unhandled Oracle error and the resolution involves going to metalink and opening an iTAR.

We really can't help you on this one though I would definitely see if your temp tablespace is really temp.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)