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

Hi Thomas:

You are really really helpful. The answer are precise and applicable as usual. I have fixed the problem.

Thanks a lot for your great help.

Best regards,

Thomas Kyte (tkyte_at_us.oracle.com) wrote:
: A copy of this was sent to suisum_at_ecn.ab.ca ()
: (if that email address didn't require changing)
: On 13 Dec 98 02:23:31 GMT, you wrote:

: >Hi I got the following error. What should I do?
: >
: >ORA-01652: unable to extend temp segment by 1598 in tablespace SYSTEM

: You should immediately:

: - alter every user in your database that has SYSTEM as their temporary
: tablespace to have some OTHER tablespace as their temporary tablespace. to find
: them, issue: select username from dba_users where temporary_tablespace =
: 'SYSTEM'

: - alter every user in your database whoses DEFAULT tablespace is SYSTEM to have
: some other tablespace. (run the above query, sustitute default_tablespace for
: temporary tablespace.

: - make sure your temporary tablespace is big enough for whatever operations you
: are performing. adding datafiles to it to make it big enough.
Received on Sun Dec 13 1998 - 14:38:30 CST