> > -----Original Message-----
> > From: Jesse, Rich
> > Sent: Wednesday, October 01, 2003 9:49 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: locally managed autoallocate (was: Separate Indexes and
> > Data)
> >
> > Theoritically, perhaps, but what if an existing table needs
> > to auto-extend
> > at 1M and all that's left in the table is 16 (or whatever)
>
> (blush) Obviously, that's supposed to say "left in the tableSPACE".
9.0.1 'unable to allocate extent'
C:\Documents and Settings\Niall>sqlplus niall/niall
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Oct 2 21:59:45 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> create tablespace test_auto
2 datafile 'c:\oracle\oradata\home9i\test_auto.dbf' size 1152k
3 extent management local;
Tablespace created.
SQL> create table t1(n number,charcol char(200))
2 tablespace test_auto
3 ;
Table created.
SQL> select count(*) from dba_extents where segment_name='T1';
COUNT(*)
----------
1
SQL> begin
2 for i in 1..14 loop
3 execute immediate 'alter table t1 allocate extent';
4 end loop;
5 end;
6 /
PL/SQL procedure successfully completed.
SQL> analyze table t1 compute statistics;
Table analyzed.
SQL> select count(*) from dba_extents where segment_name='T1';
COUNT(*)
----------
15
SQL> alter table t1 allocate extent;
Table altered.
SQL> select count(*) from dba_extents where segment_name='T1';
COUNT(*)
----------
16
SQL> alter table t1 allocate extent;
alter table t1 allocate extent
*
ERROR at line 1:
ORA-01653: unable to extend table NIALL.T1 by 128 in tablespace
TEST_AUTO
SQL> select bytes from dba_free_space where tablespace_name='TEST_AUTO';
BYTES
----------
65536
SQL> create table tX(n number,charcol char(200))
2 tablespace test_auto;
Table created.
Niall
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Niall Litchfield
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
