Re: ORA-01652: unable to extend temp segment by 1598 in tablespace

Hi all:

Thank you very much for all of your input.

The problem is one of the user was created with default tablespace = SYSTEM. So I have changed it and just work fine.

Best regards,

Francis Wong (fwong_at_globalserve.net) wrote:
: May be you should create a separete tablespace TEMP specially for sorting
: and change the default TEMPORARY_TABLESPACE to TEMP instead of using
: SYSTEM.

: suisum_at_ecn.ab.ca wrote in article <367324b9.0_at_ecn.ab.ca>...
: > Hi:
: >
: > I got the following error. What should I do?
: >
: > ORA-01652: unable to extend temp segment by 1598 in tablespace SYSTEM
: >
: >
: > --
: > Best regards,
: >

--
Best regards, Received on Sun Dec 13 1998 - 18:44:30 CST