Re: ORA-01630: altough I have enough space in temp tablespace
From: MGZ <member_at_dbforums.com>
Date: 17 Jul 2002 07:15:26 GMT
Message-ID: <3d35198e$3_at_usenetgateway.com>
Date: 17 Jul 2002 07:15:26 GMT
Message-ID: <3d35198e$3_at_usenetgateway.com>
Well it looks like your MAXEXTENTS limit has been reached. You can always add more. Depending on the current size of the tablespace and if you have autoextend on, it may not increase the size but if it is due to the fact that autoextend is not on and you are out of space, you have little choice but to increase the size or add another datafile.
You can try:
alter tablespace temp default storage (maxextents 5000);
Maybe that will fix you up.
-- Posted via dBforums http://dbforums.comReceived on Wed Jul 17 2002 - 09:15:26 CEST