oracle 10g用imp导入数据的时候报错:ORA-01658: 无法为表空间 MAXDATA 中的段创建 INITIAL 区具体的报错信息是:
IMP-00017: 由于 ORACLE 错误 1658, 以下语句失败:
"CREATE TABLE "ONWATCHLOG" ("ONWATCHLOGID" NUMBER NOT NULL ENABLE, "DESCRIPT"
"ION" VARCHAR2(50 CHAR), "SITEID" VARCHAR2(30), "ORGID" VARCHAR2(30), "OWNUM"
"" VARCHAR2(30 CHAR), "OBJECTNAME" VARCHAR2(30 CHAR), "APP" VARCHAR2(10 CHAR"
"), "SOURCEOBJECTID" NUMBER, "HASLD" NUMBER NOT NULL ENABLE, "SOURCEOBJECTST"
"ATUS" VARCHAR2(30 CHAR), "RECORDTIME" DATE, "LOGCONTENT" VARCHAR2(3200 CHAR"
"), "LOCATION" VARCHAR2(30 CHAR), "ROWSTAMP" VARCHAR2(40 CHAR) NOT NULL ENAB"
"LE, "RECORDPERSON" VARCHAR2(30 CHAR)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAX"
"TRANS 255 STORAGE(INITIAL 645922816 FREELISTS 1 FREELIST GROUPS 1 BUFFER_PO"
"OL DEFAULT) TABLESPACE "MAXDATA" LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 1658
ORA-01658: 无法为表空间 MAXDATA 中的段创建 INITIAL 区要怎么解决?
IMP-00017: 由于 ORACLE 错误 1658, 以下语句失败:
"CREATE TABLE "ONWATCHLOG" ("ONWATCHLOGID" NUMBER NOT NULL ENABLE, "DESCRIPT"
"ION" VARCHAR2(50 CHAR), "SITEID" VARCHAR2(30), "ORGID" VARCHAR2(30), "OWNUM"
"" VARCHAR2(30 CHAR), "OBJECTNAME" VARCHAR2(30 CHAR), "APP" VARCHAR2(10 CHAR"
"), "SOURCEOBJECTID" NUMBER, "HASLD" NUMBER NOT NULL ENABLE, "SOURCEOBJECTST"
"ATUS" VARCHAR2(30 CHAR), "RECORDTIME" DATE, "LOGCONTENT" VARCHAR2(3200 CHAR"
"), "LOCATION" VARCHAR2(30 CHAR), "ROWSTAMP" VARCHAR2(40 CHAR) NOT NULL ENAB"
"LE, "RECORDPERSON" VARCHAR2(30 CHAR)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAX"
"TRANS 255 STORAGE(INITIAL 645922816 FREELISTS 1 FREELIST GROUPS 1 BUFFER_PO"
"OL DEFAULT) TABLESPACE "MAXDATA" LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 1658
ORA-01658: 无法为表空间 MAXDATA 中的段创建 INITIAL 区要怎么解决?
--表空间
create tablespace maxdata
Datafile 'D:\OracleSoft\oracle\product\10.2.0\oradata\maximo\maxdata.dbf'
Size 1200M
Autoextend on maxsize unlimited;
表空间应该是够用的把。。是这门回事勒?请指点。
注:我导入的数据大约70G..数量很大,,