OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-01652 error (12.1.0.1.0, linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01652 error [message #640501]

Wed, 29 July 2015 13:14

kapilavastu
Messages: 9
Registered: July 2015

Junior Member

Since moving to 12c under linux, we keep receiving this error.

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

I ran below query and it shows free space. can any one point me into what needs to be checked.

SELECT * from DBA_TEMP_FREE_SPACE;

TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
TEMP 103078133760 103078133760 60231254016

Report message to a moderator

[Message index]

		ORA-01652 error By: kapilavastu on Wed, 29 July 2015 13:14
		Re: ORA-01652 error By: Michel Cadot on Wed, 29 July 2015 13:18
		Re: ORA-01652 error By: Michel Cadot on Wed, 29 July 2015 13:20
		Re: ORA-01652 error By: kapilavastu on Fri, 21 August 2015 17:06
		Re: ORA-01652 error By: Michel Cadot on Sat, 22 August 2015 00:03
		Re: ORA-01652 error By: EdStevens on Mon, 24 August 2015 06:32
		Re: ORA-01652 error By: kapilavastu on Mon, 24 August 2015 19:20
		Re: ORA-01652 error By: kapilavastu on Mon, 24 August 2015 22:30
		Re: ORA-01652 error By: BlackSwan on Mon, 24 August 2015 23:01
		Re: ORA-01652 error By: EdStevens on Tue, 25 August 2015 06:14
		Re: ORA-01652 error By: BlackSwan on Wed, 29 July 2015 13:19

Previous Topic:	IDLE_TIME terminates the JDBC connection
Next Topic:	PGA required for optimal and one-pass execution

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 15:17:28 CDT 2024