下面都是一些具体的实验和总结性的内容。

一，分区表的相关实验
创建一个列表分区表
create table t3(id number,city varchar2(10))
partition by list(city)
(
partition p1 values ('SH','JS','ZJ') ,
partition p2 values ('BJ','TJ','HB') ,
partition p3 values ('GZ','SZ') ,
partition p_others values (default)
);

create or replace procedure proc1
as
begin
 for i in 1..1000
 loop
  execute immediate
  'INSERT INTO T3   values(:x,:y)' USING i,'SH';
 end loop;
end;
/

exec proc1

create or replace procedure proc1
as
begin
 for i in 1001..2000
 loop
  execute immediate
  'INSERT INTO T3   values(:x,:y)' USING i,'JS';
 end loop;
end;
/

exec proc1

create or replace procedure proc1
as
begin
 for i in 2001..3000
 loop
  execute immediate
  'INSERT INTO T3   values(:x,:y)' USING i,'ZJ';
 end loop;
end;
/

exec proc1

create or replace procedure proc1
as
begin
 for i in 3001..4000
 loop
  execute immediate
  'INSERT INTO T3   values(:x,:y)' USING i,'BJ';
 end loop;
end;
/

exec proc1

create or replace procedure proc1
as
begin
 for i in 4001..5000
 loop
  execute immediate
  'INSERT INTO T3   values(:x,:y)' USING i,'TJ';
 end loop;
end;
/

exec proc1

create or replace procedure proc1
as
begin
 for i in 5001..6000
 loop
  execute immediate
  'INSERT INTO T3   values(:x,:y)' USING i,'GZ';
 end loop;
end;
/

exec proc1

create or replace procedure proc1
as
begin
 for i in 6001..7000
 loop
  execute immediate
  'INSERT INTO T3   values(:x,:y)' USING i,'HB';
 end loop;
end;
/

exec proc1

create or replace procedure proc1
as
begin
 for i in 7001..8000
 loop
  execute immediate
  'INSERT INTO T3   values(:x,:y)' USING i,'SZ';
 end loop;
end;
/

exec proc1

create or replace procedure proc1
as
begin
 for i in 8001..10000
 loop
  execute immediate
  'INSERT INTO T3   values(:x,:y)' USING i,'AH';
 end loop;
end;
/

exec proc1

SQL> SET linesize 200
SQL> select TABLE_NAME, TABLE_OWNER, PARTITION_NAME, SUBPARTITION_COUNT from dba_tab_partitions where table_name='T3';

TABLE_NAME                     TABLE_OWNER                    PARTITION_NAME                 SUBPARTITION_COUNT
------------------------------ --------------------