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 区要怎么解决?
或者将表空间设置为自动扩展的,并且每一次的自动扩展extens设置为比645922816大的值
create tablespace maxdata
Datafile 'D:\OracleSoft\oracle\product\10.2.0\oradata\maximo\maxdata.dbf'
Size 1200M
Autoextend on maxsize unlimited;导入的数据是70G我磁盘的容量是101G ,表空间应该是够用的把,,?我要怎么改进哈??请指点谢了
D:\OracleSoft\oracle\product\10.2.0\oradata\maximo\maxdata.dbf
到了32gb
需要为这个表空间添加数据文件。
D:\OracleSoft\oracle\product\10.2.0\oradata\maximo\maxdata.dbf
到了32gb
需要为这个表空间添加数据文件。?????????????????
我在导入文件的过程中勒,怎么实现添加新的表空间啊??
alter tablespace maxdata
add datafile 'D:\OracleSoft\oracle\product\10.2.0\oradata\maximo\maxdata02.dbf'
Size 1200M Autoextend on maxsize unlimited;