创建一个新表dept1,该表与department表有同样的表定义:
CREATE TABLE dept1 AS department WITH NO DATA; (WITH DATA)
复制表,增加fallback属性,增加次索引:
CREATE TABLE dept1, FALLBACK AS department WITH NO DATA
UNIQUE INDEX (department_name);
创建一个新表dept1,该表与department表有同样的表定义:
CREATE TABLE dept1 AS department WITH NO DATA; (WITH DATA)
复制表,增加fallback属性,增加次索引:
CREATE TABLE dept1, FALLBACK AS department WITH NO DATA
UNIQUE INDEX (department_name);