oracle分区 1.范围分区 根据数据库表中某一字段的值的范围来划分分区 create table graderecord ( sno varchar2(10), sname varchar2(20), dormitory varchar2(3), grade int ) partition by range(grade) ( partition bujige val...
select * from dba_tables where table_name LIKE SALES_RANGE% SELECT * FROM DBA_OBJECTS WHERE OWNER=SCOTTand object_name like EMP% order by object_name,subobject_name; drop table sys.SALES_RANGE1; -- 1. 时间分区 -- 1.1 创建分区表 --...