Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Stuck on insert into a global temporary table
Brian
Thank you for your suggestions. I have tried the configuration changes you suggested, but unfortunately it did not help. In particular someone suggested to create the table space as follows:
CREATE TEMPORARY TABLESPACE "IPWTEMPTS2" TEMPFILE '/home/oracle/u05/oradata/ORCL/IPWTEMPTS2.dbf' SIZE 64M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE 32767M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K; Roman
Sent via Deja.com
http://www.deja.com/
Received on Fri Jan 05 2001 - 01:03:42 CST