Home » SQL & PL/SQL » SQL & PL/SQL » Query giving ORA-01652 Error (Oracle 10G)
Query giving ORA-01652 Error [message #400298] Mon, 27 April 2009 08:06 Go to next message
bholeuday
Messages: 28
Registered: April 2009
Location: Talavali
Junior Member

Hi,

I have below create table statement which is giving error on execution and i am supposed to tune the same

ALTER SESSION SET SORT_AREA_SIZE = 5000000
/
ALTER SESSION SET HASH_AREA_SIZE = 5000000
/


Create table abc
nologging
as
select e1.*
from events_log e1,
(select /*+ Parallel(td,4,1) */ distinct event_log_id from temp_eventslog td) t
where e1.event_log_id = t.event_log_id;


Error :-

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

What may be the possible reasons ??

Where can i tune the queries as the tables are very huge.

Thanks in advance Smile
Re: Query giving ORA-01652 Error [message #400306 is a reply to message #400298] Mon, 27 April 2009 08:25 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

What may be the possible reasons ??

There is not enough space in TEMP tablespace.

Regards
Michel
Previous Topic: Encryption
Next Topic: Get record by length
Goto Forum:
  


Current Time: Fri Dec 09 07:59:22 CST 2016

Total time taken to generate the page: 0.17629 seconds