Home » SQL & PL/SQL » SQL & PL/SQL » how to reslove table spaces
how to reslove table spaces [message #241599] Wed, 30 May 2007 02:37 Go to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
hi,

CODE]

while I am runing sql query. iam getting those error.

unable to extend temp segemant by 128 in tablespace temp_table

how to reslove that.[/CODE]
Re: how to reslove table spaces [message #241600 is a reply to message #241599] Wed, 30 May 2007 02:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First idea: extend your temporary tablespace.
Second idea: optimize your statement.

Regards
Michel
Re: how to reslove table spaces [message #241603 is a reply to message #241599] Wed, 30 May 2007 02:47 Go to previous message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
thanks alot.

Thanks,
Srinivas
Previous Topic: STS_ERROR :ORA-01821
Next Topic: Can put nls format into procedure......
Goto Forum:
  


Current Time: Fri Dec 02 16:17:57 CST 2016

Total time taken to generate the page: 0.24264 seconds