Home » RDBMS Server » Server Administration » URGENT! HELP! ORA-01652: unable to extend temp segment by 22392 in tablespace TEMP :-1652
URGENT! HELP! ORA-01652: unable to extend temp segment by 22392 in tablespace TEMP :-1652 [message #56562] Tue, 08 April 2003 17:18 Go to next message
Tony
Messages: 190
Registered: June 2001
Senior Member
Hi,
I'm getting the following error on a database on the TEMP tablespace:

ORA-01652: unable to extend temp segment by 22392 in tablespace TEMP :-1652

I've already increased the size of the TEMP tablespace from 500M to 1000M and also changed the max extents to unlimited. But still facing the error. The "by 22392" keeps increasing everytime.

Following is the current settings
TEMP - Storage: 1000M
Extents
Initial Size: 504K
Next Size: 504K
Increment Size by : 0%
Minimum Number: 1
maximum number : 2147483645 (Unlimited)

Help Please
Tony

Report message to a moderator

Re: URGENT! HELP! ORA-01652: unable to extend temp segment by 22392 in tablespace TEMP :-1652 [message #56563 is a reply to message #56562] Tue, 08 April 2003 17:56 Go to previous message
Tony
Messages: 190
Registered: June 2001
Senior Member
Never mind. Some idiot was running a query for a whole lifetime worth of data without any date parameters. GRRRRRRRRR......

Report message to a moderator

Previous Topic: Getting more REDO - WHY? *** HELP ***
Next Topic: About Incremental Export/Import
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 29 13:00:17 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.