17,089
社区成员
发帖
与我相关
我的任务
分享
DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'STORAGE',false);
--怎么会?我试下来可以的,不过我把表空间列表那里换成了我的环境上的表空间而已
scott@ORA11GR2> CREATE TABLE T_FARS_SRC_DATA_KEY_MAP
2 (
3 JOB_ID NUMBER(10,0) NOT NULL ENABLE,
4 PERSON_ID VARCHAR2(50) NOT NULL ENABLE, --??????
5 IMAGE_ID VARCHAR2(50) NOT NULL ENABLE, --??????
6 SEQ_KEY NUMBER(20,0)
7 )
8 PARTITION BY RANGE(JOB_ID) INTERVAL (1)
9 STORE IN (USERS,EXAMPLE)
10 (
11 PARTITION PART_KEY_MAP_1 VALUES LESS THAN (2)
12 );
Table created.
scott@ORA11GR2> ALTER TABLE T_FARS_SRC_DATA_KEY_MAP
2 ADD CONSTRAINT P$KEYMAP__JOB_PERSON_IMAGE PRIMARY KEY (JOB_ID, PERSON_ID, IMAGE_ID);
Table altered.
--去掉那个多余的;
CREATE TABLE T_FARS_SRC_DATA_KEY_MAP
(
JOB_ID NUMBER(10,0) NOT NULL ENABLE,
PERSON_ID VARCHAR2(50) NOT NULL ENABLE, --??????
IMAGE_ID VARCHAR2(50) NOT NULL ENABLE, --??????
SEQ_KEY NUMBER(20,0)
)
PARTITION BY RANGE(JOB_ID) INTERVAL (1)
STORE IN (TS_FARS_PERSON_DATA1,TS_FARS_PERSON_DATA2,TS_FARS_PERSON_DATA3,TS_FARS_PERSON_DATA4)
(
PARTITION PART_KEY_MAP_1 VALUES LESS THAN (2)
);
ALTER TABLE T_FARS_SRC_DATA_KEY_MAP
ADD CONSTRAINT P$KEYMAP__JOB_PERSON_IMAGE PRIMARY KEY (JOB_ID, PERSON_ID, IMAGE_ID);