以下为ATS_XDSI表空间创建语句
CREATE TABLESPACE ats_xdsi
NOLOGGING
DATAFILE 'F:\szpt\ats_xdsi.DBF'
SIZE 1024M
AUTOEXTEND ON
NEXT 10M maxsize unlimited
EXTENT MANAGEMENT LOCAL autoallocate;
在导入dmp文件时候报错信息、
IMP-00017: 由于 ORACLE 错误 1659, 以下语句失败:
"CREATE TABLE "SERIES" ("PK" NUMBER NOT NULL ENABLE, "STUDY_FK" NUMBER, "INS"
"T_CODE_FK" NUMBER, "SERIES_IUID" VARCHAR2(64) NOT NULL ENABLE, "SERIES_NO" "
"VARCHAR2(64), "MODALITY" VARCHAR2(64), "BODY_PART" VARCHAR2(64), "LATERALIT"
"Y" VARCHAR2(64), "SERIES_DESC" VARCHAR2(64), "INSTITUTION" VARCHAR2(64), "S"
"TATION_NAME" VARCHAR2(64), "DEPARTMENT" VARCHAR2(64), "PERF_PHYSICIAN" VARC"
"HAR2(64), "PERF_PHYS_FN_SX" VARCHAR2(64), "PERF_PHYS_GN_SX" VARCHAR2(64), ""
"PERF_PHYS_I_NAME" VARCHAR2(64), "PERF_PHYS_P_NAME" VARCHAR2(64), "PPS_START"
"" TIMESTAMP (6), "PPS_IUID" VARCHAR2(64), "SERIES_CUSTOM1" VARCHAR2(64), "S"
"ERIES_CUSTOM2" VARCHAR2(64), "SERIES_CUSTOM3" VARCHAR2(64), "NUM_INSTANCES""
" NUMBER, "SRC_AET" VARCHAR2(64), "EXT_RETR_AET" VARCHAR2(64), "RETRIEVE_AET"
"S" VARCHAR2(64), "FILESET_IUID" VARCHAR2(64), "FILESET_ID" VARCHAR2(64), "A"
"VAILABILITY" NUMBER, "SERIES_STATUS" NUMBER, "CREATED_TIME" TIMESTAMP (6), "
""UPDATED_TIME" TIMESTAMP (6)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 25"
"5 STORAGE(INITIAL 134217728 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAU"
"LT) TABLESPACE "ATS_XDSI" LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 1659
ORA-01659: 无法分配超出 3 的 MINEXTENTS (在表空间 ATS_XDSI 中)麻烦大伙帮忙分析,解决一下,不胜感激。Oracle
CREATE TABLESPACE ats_xdsi
NOLOGGING
DATAFILE 'F:\szpt\ats_xdsi.DBF'
SIZE 1024M
AUTOEXTEND ON
NEXT 10M maxsize unlimited
EXTENT MANAGEMENT LOCAL autoallocate;
在导入dmp文件时候报错信息、
IMP-00017: 由于 ORACLE 错误 1659, 以下语句失败:
"CREATE TABLE "SERIES" ("PK" NUMBER NOT NULL ENABLE, "STUDY_FK" NUMBER, "INS"
"T_CODE_FK" NUMBER, "SERIES_IUID" VARCHAR2(64) NOT NULL ENABLE, "SERIES_NO" "
"VARCHAR2(64), "MODALITY" VARCHAR2(64), "BODY_PART" VARCHAR2(64), "LATERALIT"
"Y" VARCHAR2(64), "SERIES_DESC" VARCHAR2(64), "INSTITUTION" VARCHAR2(64), "S"
"TATION_NAME" VARCHAR2(64), "DEPARTMENT" VARCHAR2(64), "PERF_PHYSICIAN" VARC"
"HAR2(64), "PERF_PHYS_FN_SX" VARCHAR2(64), "PERF_PHYS_GN_SX" VARCHAR2(64), ""
"PERF_PHYS_I_NAME" VARCHAR2(64), "PERF_PHYS_P_NAME" VARCHAR2(64), "PPS_START"
"" TIMESTAMP (6), "PPS_IUID" VARCHAR2(64), "SERIES_CUSTOM1" VARCHAR2(64), "S"
"ERIES_CUSTOM2" VARCHAR2(64), "SERIES_CUSTOM3" VARCHAR2(64), "NUM_INSTANCES""
" NUMBER, "SRC_AET" VARCHAR2(64), "EXT_RETR_AET" VARCHAR2(64), "RETRIEVE_AET"
"S" VARCHAR2(64), "FILESET_IUID" VARCHAR2(64), "FILESET_ID" VARCHAR2(64), "A"
"VAILABILITY" NUMBER, "SERIES_STATUS" NUMBER, "CREATED_TIME" TIMESTAMP (6), "
""UPDATED_TIME" TIMESTAMP (6)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 25"
"5 STORAGE(INITIAL 134217728 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAU"
"LT) TABLESPACE "ATS_XDSI" LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 1659
ORA-01659: 无法分配超出 3 的 MINEXTENTS (在表空间 ATS_XDSI 中)麻烦大伙帮忙分析,解决一下,不胜感激。Oracle
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货