Oracle Table Partitioning Experience

Since the system is a modification of the former batch system, it is necessary to partition the table

1, has established the non-partitioned table, cannot make any table partition operation, such as: Add, delete, merge, split can not operate

2, the partitioned table retains at least 1 partitions, that is, cannot be completely deleted

3, if there is a default partition, cannot add the specified list value partition, can only split the original default partition to be divided into a number of partitions, and retain the default partition

CREATE TABLE T

(

Task_seqno VARCHAR2 (10),

Bankno VARCHAR2 (5)

) partition by list (Bankno)

(

Partition T_BNK values (DEFAULT)

);

--Split the default partition, T is the table name, T_BNK is the default partition, t_bnk_202 is the partition with the Value 202 divided, xxxtbs_202 is the tablespace name

Alter table T split partition T_BNK values (202) into (partition t_bnk_202 tablespace xxxtbs_202,partition T_BNK);

Oracle Table Partitioning Experience