create table emp partition by RANGE(deptno) ( partition PART01 values less than (50000), partition PART02 values less than (100000), partition PART03 values less than (300000), partition PART04 values less than (500000), partition PART05 values less than (7000000), partition PARTMAX values less than (MAXVALUE) ) tablespace Test as select level as empno, dbms_random.string('A',30) as ename, dbms_random.string('B',7) as job, sysdate - mod(level,100) as hire_date, dbms_random.value(1,1000) as comm, dbms_random.value(1,10000) as salary, mod(level,1000000)+1 as deptno from dual connect by level <= 1000000; |
版权声明:本文由会员 LorrieL 首发于51Testing软件测试论坛[2015新年活动]栏目。
原创作品,转载时请务必以超链接形式标明本文原始出处、作者信息和本声明,否则将追究法律责任。