RE: locally managed autoallocate (was: Separate Indexes and Data)

> > -----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: niall.litchfield_at_dial.pipex.com

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: ListGuru_at_fatcity.com (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).