Home » RDBMS Server » Server Administration » ORA-1652: unable to extend temp segment by 7680 in tablespace
ORA-1652: unable to extend temp segment by 7680 in tablespace [message #53160] Thu, 29 August 2002 10:10 Go to next message
Lena
Messages: 17
Registered: August 2002
Junior Member
Hi there
I have a production server version 8i 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 TEMP3
Tue Aug 27 01:06:46 2002
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

after did we recycle Oracle 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 database
Any help would be great
Thanks
Lena

Report message to a moderator

Re: ORA-1652: unable to extend temp segment by 7680 in tablespace [message #53167 is a reply to message #53160] Thu, 29 August 2002 21:00 Go to previous messageGo to next message
Eric He
Messages: 2
Registered: August 2002
Junior Member
Hi,

I think the TEMP tablespace assigned to this user is too small for the sort, and you did not specify this TEMP tablespace can autoextend.

Eric

Report message to a moderator

Re: ORA-1652: unable to extend temp segment by 7680 in tablespace [message #53170 is a reply to message #53160] Fri, 30 August 2002 09:15 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
if the TEMP3 tablespace is of type 'temporary', then after the recycle of the database, the tablespace size goes to zero. Confirm the type of the tablespace TEMP3.

Anyhow, in your case, looks like the TEMP3 is small for whatever kind of work you are trying to do.

Good luck.

Report message to a moderator

Previous Topic: Logging into the SQL Plus
Next Topic: user access
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 11:49:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.