IMP-00003: 遇到 ORACLE 错误 1658
ORA-01658: 无法为表空间 MOF 中的段创建 INITIAL 区
IMP-00017: 由于 ORACLE 错误 1658, 以下语句失败:
"CREATE TABLE "GL_BUDGET_BILL_INTERFACE" ("BILLTYPE_CODE" VARCHAR2(42) NOT N"
"ULL ENABLE, "BILL_ID" VARCHAR2(38) NOT NULL ENABLE, "BILL_NO" VARCHAR2(42),"
" "BILL_DATE" VARCHAR2(30), "RG_CODE" VARCHAR2(42), "SET_YEAR" NUMBER(4, 0) "
"NOT NULL ENABLE, "VOU_MONEY" NUMBER(16, 2), "REMARK" VARCHAR2(300), "IS_VAL"
"ID" NUMBER(1, 0) NOT NULL ENABLE, "IS_END" NUMBER(1, 0) NOT NULL ENABLE, "C"
"OMFIRM_USER" VARCHAR2(38), "COMFIRM_DATE" VARCHAR2(20), "IMPORT_DATE" VARCH"
"AR2(20), "IMPORT_USER" VARCHAR2(38), "EXPORT_DATE" VARCHAR2(20), "EXPORT_US"
"ER" VARCHAR2(38), "EXPORT_NUM" NUMBER(4, 0), "CREATE_USER" VARCHAR2(38), "C"
"REATE_DATE" VARCHAR2(20), "LATEST_OP_DATE" VARCHAR2(20), "LATEST_OP_USER" V"
"ARCHAR2(38), "LAST_VER" VARCHAR2(30), "IS_MODIFY" VARCHAR2(1) NOT NULL ENAB"
"LE, "ST_CODE" VARCHAR2(42), "SET_MONTH" VARCHAR2(2) NOT NULL ENABLE, "DEFIN"
"E_CODE" VARCHAR2(10), "IS_BUSINCREASE" NUMBER(1, 0), "CTRLLEVEL" NUMBER(2, "
"0), "CCID" NUMBER, "RCID" NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRAN"
"S 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAU"
"LT) TABLESPACE "MOF" LOGGING NOCOMPRESS"
ORA-01658: 无法为表空间 MOF 中的段创建 INITIAL 区
IMP-00017: 由于 ORACLE 错误 1658, 以下语句失败:
"CREATE TABLE "GL_BUDGET_BILL_INTERFACE" ("BILLTYPE_CODE" VARCHAR2(42) NOT N"
"ULL ENABLE, "BILL_ID" VARCHAR2(38) NOT NULL ENABLE, "BILL_NO" VARCHAR2(42),"
" "BILL_DATE" VARCHAR2(30), "RG_CODE" VARCHAR2(42), "SET_YEAR" NUMBER(4, 0) "
"NOT NULL ENABLE, "VOU_MONEY" NUMBER(16, 2), "REMARK" VARCHAR2(300), "IS_VAL"
"ID" NUMBER(1, 0) NOT NULL ENABLE, "IS_END" NUMBER(1, 0) NOT NULL ENABLE, "C"
"OMFIRM_USER" VARCHAR2(38), "COMFIRM_DATE" VARCHAR2(20), "IMPORT_DATE" VARCH"
"AR2(20), "IMPORT_USER" VARCHAR2(38), "EXPORT_DATE" VARCHAR2(20), "EXPORT_US"
"ER" VARCHAR2(38), "EXPORT_NUM" NUMBER(4, 0), "CREATE_USER" VARCHAR2(38), "C"
"REATE_DATE" VARCHAR2(20), "LATEST_OP_DATE" VARCHAR2(20), "LATEST_OP_USER" V"
"ARCHAR2(38), "LAST_VER" VARCHAR2(30), "IS_MODIFY" VARCHAR2(1) NOT NULL ENAB"
"LE, "ST_CODE" VARCHAR2(42), "SET_MONTH" VARCHAR2(2) NOT NULL ENABLE, "DEFIN"
"E_CODE" VARCHAR2(10), "IS_BUSINCREASE" NUMBER(1, 0), "CTRLLEVEL" NUMBER(2, "
"0), "CCID" NUMBER, "RCID" NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRAN"
"S 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAU"
"LT) TABLESPACE "MOF" LOGGING NOCOMPRESS"
解决方案 »
- Oracle-01507 Oracle-00600
- java Clob
- 用delphi语句一次插入100000以上的记录
- 触发器if问题
- 查询条件需要根据表中某些列的值来变化,这样的查询如何实现?
- 求助,ORA-00600错误
- 如何通过ps/sql插入一个字符串到blob字段?
- 关于TNS的棘手问题,请高手过目
- 在oracle存储过程中如何把R2,R3,R4,R5中用数组把R2 R3 R4 R5分离出来
- oracle job时间被改变
- 存储过程 报“ORA-06502: PL/SQL: 数字或值错误 ” 找到原因,找不到解决办法(更改长度行不通因为已超过32767),求各位大侠帮忙!
- 请教 oracle10g sql问题
select * from database_properties where property_name='DEFAULT_TEMP_TABLESPACE';
创建新的临时表空间
create temporary tablespace temp01 tempfile 'D:\ORACLE\ORADATA\TFJS\TEMP01.DBF'
size 1000M autoextend on;
修改默认表空间
alter database default temporary tablespace temp01;
解决步骤:
查看表空间大小:
select SEGMENT_TYPE,owner,sum(bytes)/1024/1024 from
dba_segments
where tablespace_name=MOF'
group by segment_type,owner
更改表空间大小:
alter tablespace MOF add datafile 'D:\ORACLE\ORADATA\CJF\TEMP03.ora' size 10m;
select tablespace_name,file_name,ceil(bytes/1024/1024) mb from dba_data_files order by 1;增加:
Alter database datafile ‘…..’ resize 100m;