Увеличение размера раздела при его переименовании

create table ama
(
        ama_file    varchar(13),
        started     date,
        duration    integer
        ...
)
compress 
pctfree 0
pctused 0
partition by list(file)
(
        partition empty values (null)
)
/
create bitmap index ama_file on ama(ama_file) local
/
create bitmap index ama_started on ama(started) local
/
create bitmap index ama_duration on ama(duration) local
/
...

SQL> select partition_name,
  2  sum(case when segment_type like 'TABLE%' then bytes else 0 end)/1024/1024 as data_size,
  3  sum(case when segment_type like 'INDEX%' then bytes else 0 end)/1024/1024 as index_size,
  4  sum(bytes)/1024/1024 as full_size
  5  from user_segments
  6  where partition_name='P20051408.01'
  7  group by partition_name
  8  /

PARTITION_NAME                  DATA_SIZE INDEX_SIZE  FULL_SIZE
------------------------------ ---------- ---------- ----------
P20051408.01                           31    38.3125    69.3125

Elapsed: 00:00:00.08
SQL> 
SQL> alter table ama add partition "P01.2005081402" values ('01.2005081402')
  2  /

Table altered.

Elapsed: 00:00:14.95
SQL> update ama set ama_file='01.2005081402' where ama_file='20051408.01'
  2  /

639886 rows updated.

Elapsed: 00:53:16.48
SQL> alter table ama drop partition "P20051408.01"
  2  /

Table altered.

Elapsed: 00:05:43.12
SQL> 
SQL> select partition_name,
  2  sum(case when segment_type like 'TABLE%' then bytes else 0 end)/1024/1024 as data_size,
  3  sum(case when segment_type like 'INDEX%' then bytes else 0 end)/1024/1024 as index_size,
  4  sum(bytes)/1024/1024 as full_size
  5  from user_segments
  6  where partition_name='P01.2005081402'
  7  group by partition_name
  8  /

PARTITION_NAME                  DATA_SIZE INDEX_SIZE  FULL_SIZE
------------------------------ ---------- ---------- ----------
P01.2005081402                         53    42.8125    95.8125

Elapsed: 00:00:01.92

SQL> CREATE TABLE TST_PART
  2  (
  3    C1  NUMBER(20),
  4    C2  NUMBER(20)
  5  )
  6  TABLESPACE USERS
  7  STORAGE    (INITIAL  10M NEXT 10M )
  8  PARTITION BY LIST (C1)
  9  (
 10    PARTITION P1 VALUES (1),
 11    PARTITION P2 VALUES (2)
 12  );

Table created.

SQL> alter table tst_part add partition p3 values(3);

Table altered.

SQL> select partition_name,initial_extent from user_tab_partitions where table_n
ame='TST_PART';

PARTITION_NAME                 INITIAL_EXTENT
------------------------------ --------------
P1                                   10485760
P2                                   10485760
P3                                   10485760

SQL> select partition_name,bytes from dba_segments where segment_name='TST_PART'
;

PARTITION_NAME                      BYTES
------------------------------ ----------
P1                               10485760
P2                               10485760
P3                               10485760