RE: MAX_EXTENTS

From: Henry Poras <Henry.Poras_at_ctp.com>
Date: Thu, 9 Nov 2000 17:58:07 -0500
Message-Id: <10675.121665@fatcity.com>

How about this? I thought that the maximum extent limit for a 2K database (7.3.4) was 121 extents. Apparantly not.

SQL> SELECT name, value
  2 FROM v$parameter
  3 WHERE name = 'db_block_size';

NAME

---

VALUE

---

---

db_block_size

2048  

SQL> desc blocksize

 Name                            Null?    Type
 ------------------------------- -------- ----
 INPUT                                    CHAR(100)

SQL> SELECT segment_name, segment_type, extents, max_extents   2 FROM dba_segments
  3 WHERE segment_name = 'BLOCKSIZE'
  4

SQL> / SEGMENT_NAME SEGMENT_TYPE EXTENTS MAX_EXTENTS

• ----------------- --------- -----------

BLOCKSIZE    TABLE                     1         150

SQL> INSERT INTO blocksize VALUES ('A');

1 row created.

SQL> INSERT INTO blocksize SELECT * FROM blocksize   2 /

1 row created.

SQL> / 2048 rows created.

SQL> /
INSERT INTO blocksize SELECT * FROM blocksize *
ERROR at line 1:
ORA-01631: max # extents (150) reached in table SYSTEM.BLOCKSIZE

SQL> SELECT segment_name, segment_type, extents, max_extents   2 FROM dba_segments
  3 WHERE segment_name = 'BLOCKSIZE';

SEGMENT_NAME SEGMENT_TYPE EXTENTS MAX_EXTENTS

• ----------------- --------- -----------

BLOCKSIZE    TABLE                   150         150

-----Original Message-----

From: TheOracle DBA [mailto:theoracledba_at_lycos.com] Sent: Thursday, November 09, 2000 1:43 PM To: Multiple recipients of list ORACLE-L Subject: Re: MAX_EXTENTS

In the DBA_TABLESPACE view, the column "max_extents" refers to the default storage paramters for any segment created in that specific TS without explicit storage settings,

so you can set the DEF to be max=400, but create a table TESTMAXEXT and give Received on Thu Nov 09 2000 - 16:58:07 CST