ORA-1652: unable to extend temp segment by 7680 in tablespace

From: Maria <evoradba_at_yahoo.ca>
Date: 29 Aug 2002 19:47:18 -0700
Message-ID: <351fd9d6.0208291847.bbdbb5a_at_posting.google.com>

Hi there
I have a production oracle database server version 8170 running on sun.We have scripts that run at night and we found this in the oracle log file
ORA-1652: unable to extend temp segment by 7680 in tablespace TEM3 Tue Aug 27 01:06:46 2002b
ORA-1652: unable to extend temp segment by 7680 in tablespace TEMP3 Tue Aug 27 01:06:48 2002
ORA-1652: unable to extend temp segment by 7680 in tablespace TEMP3 Tue Aug 27 01:13:24 2002
ORA-1652: unable to extend temp segment by 7680 in tablespace TEMP3 Tue Aug 27 01:13:25 2002
ORA-1652: unable to extend temp segment by 7680 in tablespace TEMP3 Tue Aug 27 01:13:26 2002
ORA-1652: unable to extend temp segment by 7680 in tablespace TEMP3 Tue Aug 27 01:13:27 2002

But the strange thing is that not alwasy fails, we keep running the same days we get the error message, I though that recycles itself and did we regain the space that was taken up on Sunday night? Doesn't Oracle deal with this automatically

How do we preform a ctas and make sure that triggers also come over from the other databasebes
Any help would be great
Thanks
Lena Received on Fri Aug 30 2002 - 04:47:18 CEST