表分区——基于日期数据类型的分区操作-oracle数据库操作
CREATE TABLE ordMast( Orderno VARCHAR2(5) CONSTRAINT prim PRIMARY KEY , Odate Date, Vencode VARCHAR2(5) CONSTRAINT fk_ven REFERENCES vendorMaster(vencode), Ostatus CHAR(1) CHECK (ostatus IN ('p','c')) Deldate date) PARTITION BY RANGE(odate)( PARTITION om1 VALUES LESS THAN(to_date('1999-06-01','YYYY-MM-DD')), PARTITION om2 VALUES LESS THAN(to_date('1999-07-01','YYYY-MM-DD')));
文件大小：1.19MB
评论区