创建表空间语句
create tablespace ips_ora_1 datafile '/home/oracle/app/oradata/ips_ora_1.dbf'size 20480m;
报错内容:
IMP-00017: following statement failed with ORACLE error 959:
"CREATE TABLE "CONFIG_TERMINAL_TYPE" ("TYPE_ID" VARCHAR2(16) NOT NULL ENABLE"
", "TYPE_NAME" VARCHAR2(64) NOT NULL ENABLE, "BOX_NUM" NUMBER(3, 0) NOT NULL"
" ENABLE, "COLUMN_NUM" NUMBER(2, 0) NOT NULL ENABLE, "LINE_NUM" NUMBER(2, 0)"
" NOT NULL ENABLE, "B_LINE" VARCHAR2(30), "M_LINE" VARCHAR2(30), "S_LINE" VA"
"RCHAR2(30), "M_POS_CODE" VARCHAR2(200), "PICTURE_DATA" BLOB, "PICTURE_TITLE"
"" VARCHAR2(100), "PICTURE_SIZE" NUMBER(10, 0), "PICTURE_ALIAS_NAME" VARCHAR"
"2(100), "REMARKS" VARCHAR2(300), "EDIT_USERID" VARCHAR2(32), "EDIT_USERNAME"
"" VARCHAR2(32), "EDIT_TIME" TIMESTAMP (6), "INSERT_TIME" TIMESTAMP (6) NOT "
"NULL ENABLE, "IS_POST" CHAR(1) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INIT"
"RANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELIS"
"TS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "IPS_DB_TBS" LOGGING"
" NOCOMPRESS LOB ("PICTURE_DATA") STORE AS BASICFILE (TABLESPACE "IPS_DB_TB"
"S" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE(INI"
"TIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_P"
"OOL DEFAULT))"
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'IPS_DB_TBS' does not exist
åªæ¯è¿ä¸ªè¡¨ä¸åå¨æ¯ä¹ï¼
é£æ¯ä¸æ¯åªè½å¨å¯¼å
¥åï¼å
åç¬å建è¿ä¸ªè¡¨ç©ºé´ï¼ç¶åæå¨å¯¼å
¥ï¼
ææ¯ä»å
¶ä»æ°æ®åºéé¢å¯¼åºæ¥çï¼å¨å¦ä¸ä¸ªæå¡å¨ä¸å导å
¥ï¼æ¯å¦è¿è¦ä¿æ表空é´ååä¸è´å¢
IPS_DB_TBSæ¯è¡¨ç©ºé´ï¼ä¸æ¯è¡¨ã
ä¸è¬imp导å
¥çæ¶åï¼åºè¯¥å
建ç«è·å¯¼åºæ°æ®åºååç表空é´ï¼ä¹ä¸ç¥éä½ å°åºå 个表空é´ï¼ä¸è¬è¿ç§æ
åµé½æ¯ä¸ä¸ªè¡¨ç©ºé´ä¸ä¸ªè¡¨ç©ºé´çæ¥éï¼ç´å°å
¨é¨é½å»ºç«å
¨äºï¼æåæä¸æ¥éã