实例讲解分区表的可用性及相关错误案例

CREATE TABLE employee

( empno int,

ename varchar2(20)

)

PARTITION BY HASH (empno)

( partition part_1 tablespace TBS_DAIMIN,

partition part_2 tablespace USERS

)

SQL> insert into employee select empno, ename from scott.emp

2 ;

14 rows created.

commit;

SQL> select * from employee partition(part_1);

EMPNO ENAME

---------- --------------------

7369 SMITH

7499 ALLEN

7654 MARTIN

7698 BLAKE

7782 CLARK

7839 KING

7876 ADAMS

7934 MILLER

8 rows selected.

SQL> select * from employee partition(part_2);

EMPNO ENAME

---------- --------------------

7521 WARD

7566 JONES

7788 SCOTT

7844 TURNER

7900 JAMES

7902 FORD

6 rows selected.