Hi All, Getting the following error in Oracle9i on AIX, unique index ORA-01652: unable to extend temp segment by 128 in tablespace USERS; though the USER tablespace is of 10gb.Could anyone provide a solution.Regards,Ashish Thomas

Questions by thomashish

Showing Answers 1 - 3 of 3 Answers

siva

  • Apr 10th, 2007
 

i think the size of the temporary tablespace is small. try to increase the size of the temporary table.

  Was this answer useful?  Yes

Daid

  • Aug 20th, 2007
 

Please Set the Undo Tablespace management auto and scope is memory and then try to do 
Thanks 

  Was this answer useful?  Yes

Aaryan

  • Jul 25th, 2012
 

Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
files to the tablespace indicated.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions