分区表的创建方法及其相关 创建分区表 CREATE TABLE ccc1 ( id number(8),name varchar2(30),sales_date date) PARTITION BY RANGE (sales_date) (PARTITION p1 VALUES LESS THAN ( TO_DATE('01-JAN-1999','DD-MON-YYYY')) tablespace zh, PARTITION p2 VALUES LESS THAN ( TO_DATE('01-JAN-2000','DD-MON-YYYY')) tablespace zh, PARTITION p3 VALUES LESS THAN ( TO_DATE('01-JAN-2001','DD-MON-YYYY')) tablespace zh, PARTITION
Copyright © 2005-2025 51CTO.COM 版权所有 京ICP证060544号
