【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了22.3.sql相关资料,希望对各位网友有所帮助!
--散列分区
CREATE TABLE EMPLOYEE
(
EMP_ID NUMBER(4),
EMP_NAME VARCHAR2(14),
EMP_ADDRESS VARCHAR2(15),
DEPARTMENT VARCHAR2(10)
)
PARTITION BY HASH (DEPARTMENT)
PARTITIONS 4
STORE IN (USERS,BIGTBS);
CREATE TABLE Employee1
(
Employee_ID varchar2 (5),
Employee_Name varchar2(20),
Department varchar2 (10)
)
PARTITION BY HASH (Department)
(
Partition D1 TABLESPACE USERS,
Partition D2 TABLESPACE USER1,
Partition D3 TABLESPACE BIGTBS
);