Re: Stuck on insert into a global temporary table

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Wed, 3 Jan 2001 16:03:35 GMT
Message-ID: <3A534D57.63422E6@edcmail.cr.usgs.gov>

> CREATE TABLESPACE "IPWTEMPTS2" LOGGING
> DATAFILE '/home/oracle/u05/oradata/ORCL/IPWTEMPTS2.dbf' SIZE 64M REUSE
> AUTOEXTEND ON NEXT 640K MAXSIZE 32767M DEFAULT STORAGE ( INITIAL 256K
> NEXT 256K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) TEMPORARY
Two things for you to try.

First off, since you are on Oracle 8i, try using the new convention for creating temporary tablespaces. The new syntax is:

CREATE TEMPORARY TABLESPACE tablespace_name TEMPFILE '/dir/filename' SIZE.......
This might help you.

Second, I see that you used the "LOGGING" keyword. You might want to leave that off since temporary data does not need to be logged.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Wed Jan 03 2001 - 10:03:35 CST