OraFAQ Forum: Performance Tuning » Problem on temporary tablespace

Home » RDBMS Server » Performance Tuning » Problem on temporary tablespace

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

Problem on temporary tablespace [message #158768]

Tue, 14 February 2006 05:07

loveoracle
Messages: 41
Registered: February 2006
Location: Mumbai

Member

Dear All,

While creating on materialized view i received the following error;

ORA- 01652:unable to extend temp segment by 256 in tablespace mytemp.

But I already set that tablespace as autoextend and maxsize in unlimited. this my developement database.
also disk have 20 gb free space.
Then why should It gives me error.
I am in comfusion, please help.
Thanks in advance.
Prathamesh.

Report message to a moderator

Re: Problem on temporary tablespace [message #158838 is a reply to message #158768]

Tue, 14 February 2006 11:48

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

Are you sure? Double check the info in dba_tablespaces and dba_data_files for the MYTEMP tablespace. Note that temp segment in that error message does not necessarily mean temp tablespace.

Report message to a moderator

Previous Topic:	parallel hint
Next Topic:	SQL Query not using Composite Index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 15:09:13 CST 2024