ora-1530: max # extents (121) reached??

From: Brian Yan <by999_at_hotmail.com>
Date: Wed, 15 Dec 1999 17:31:06 GMT
Message-ID: <838j8q$a4l$1@nnrp1.deja.com>

Hi there,

I got the following error when I tried to create a table:

SQL> create table extents_bk as
  2 select * from extents;
select * from extents

              *
ERROR at line 2:
ORA-01630: max # extents (121) reached in temp segment in tablespace TS_MNTR I ran this command in user MONITOR, whose default tablespace is TS_MNTR, temporary is TEMP.

The information about these two tablespaces are as follows,

CREATE TABLESPACE TEMP
    DATAFILE '/u02/ORACLE/DSNR/temp01.dbf' SIZE 20480K AUTOEXTEND OFF     DEFAULT STORAGE(INITIAL 256K

                    NEXT 256K
                    MINEXTENTS 1
                    MAXEXTENTS 121
                    PCTINCREASE 0)

    ONLINE
    TEMPORARY; CREATE TABLESPACE TS_MNTR
    DATAFILE '/u05/ORACLE/DSNR/mntr_01.dbf' SIZE 102400K AUTOEXTEND OFF     DEFAULT STORAGE(INITIAL 10K

                    NEXT 10K
                    MINEXTENTS 1
                    MAXEXTENTS 121
                    PCTINCREASE 0)

    ONLINE
    PERMANENT; My question is: why does Oracle complain temp segment in TS_MNTR? Since I have defined the temporary tablespace for user MONITOR, isn't it supposed to use temp segment in TEMP instead of TS_MNTR? How to fix this problem?

Thank you in advance!

Brian

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 15 1999 - 11:31:06 CST