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

Home -> Community -> Usenet -> c.d.o.server -> Re: INSERT INTO TEMPORARY TABLE CAUSES ORA-600 2656 WITH TEMPORARY TABLESPACES

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sat, 10 May 2003 06:11:46 +1000
Message-ID: <JNTua.31744$1s1.464444@newsfeeds.bigpond.com>

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3EBBAE01.46FED5D3_at_exxesolutions.com...
> 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.

Of course you can: create global temporary table blah (col1 char(5)) on delete preserve rows;

The issue is not inserting into a temporary table; it's his version, which is pre-release and archaic.

Regards
HJR Received on Fri May 09 2003 - 15:11:46 CDT