ITPub博客

如果表开始设计为非分区表，以后想变更为分区表，以下是测试脚本：DROP TABLE t_partitionDROP TABLE t_nopartition--create partition tableCREATE TABLE t_partition (object_id NUMERIC,object_name VARCHAR2(200))PARTITION BY RANGE (object_id)(PARTITION pMax VALUES LESS THAN (MAXVALUE) TABLESPACE example)--creat nopartition table CREATE TABLE t_nopartition (object_id NUMERIC,object_name VARCHAR2(200))--fill data to nopartition tableINSERT INTO t_nopartition SELECT object_id,object_name FROM Dba_Objects--ex