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

Hi Maria,

Please don't cross post.

I've replied to this on comp.database.oracle.server

Regards

Richard
"Maria" <evoradba_at_yahoo.ca> wrote in message news:351fd9d6.0208291847.438b1d54_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 - 07:38:34 CEST