ITPub博客

首页 > Linux操作系统 > Linux操作系统 > imp时报对象被创建在临时表空间

imp时报对象被创建在临时表空间

原创 Linux操作系统 作者:bjup 时间:2011-01-06 21:26:32 0 删除 编辑


IMP-00017: following statement failed with ORACLE error 2195:
 "CREATE TABLE "EVENT" ("PEMGMTTIMESTAMP" DATE NOT NULL ENABLE, "NAMESPACEID""
 " NUMBER(10, 0) NOT NULL ENABLE, "PEMID" NUMBER(10, 0) NOT NULL ENABLE, "PEM"
 "TYPE" NUMBER(10, 0), "PEMSEVERITY" NUMBER(10, 0), "PEMSTATUS" NUMBER(10, 0)"
 ", "PEMNODE" VARCHAR2(64), "PEMORIGIN" VARCHAR2(512), "PEMCATALOGNAME" VARCH"
 "AR2(64), "PEMCLASSNAME" VARCHAR2(64), "PEMEXPECTANCY" VARCHAR2(64), "PEMOWN"
 "ER" VARCHAR2(64), "PEMHANDLER" VARCHAR2(64), "PEMARGS" VARCHAR2(1024), "PEM"
 "DESC" VARCHAR2(2048), "PEMDIARY" VARCHAR2(2048), "EVENTTYPE" NUMBER(2, 0), "
 ""OLDSTATE" VARCHAR2(64), "NEWSTATE" VARCHAR2(64), "ALARMVALUE" FLOAT(126), "
 ""ALARMMINRANGE" FLOAT(126), "ALARMMAXRANGE" FLOAT(126), "ALARMLEVEL" FLOAT("
 "126))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 524288"
 "00 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "EDA_EVENT" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 2195 encountered
ORA-02195: Attempt to create PERMANENT object in a TEMPORARY tablespace

解决过程:
从ORA-02195: Attempt to create PERMANENT object in a TEMPORARY tablespace中可以看到在imp时会创建EVENT表,但该表存放的
表空间EDA_EVENT为临时表空间。实际上该表空间不应用为临时表空间,查看建表空间的dll发现EDA_SUMMARY、EDA_EVENT在创建时关键字DATAFILE变成了
TEMPFILE
-2. eda_summary
 CREATE TABLESPACE EDA_SUMMARY
 TEMPFILE '/nnsdb/nns/eda_summary.dbf' SIZE 10240 M
 AUTOEXTEND ON NEXT 100M
 EXTENT MANAGEMENT LOCAL UNIFORM. SIZE 1 M;

CREATE TABLESPACE EDA_EVENT
 TEMPFILE '/nnsdb/nns/eda_event.dbf' SIZE 10240 M
 AUTOEXTEND ON NEXT 100M
 EXTENT MANAGEMENT LOCAL UNIFORM. SIZE 1 M;
 
查询表空间属性
select tablespace_name,contents from dba_tablespaces
EDA_SUMMARY TEMPORARY
EDA_EVENT TEMPORARY

删除表空间:
drop tablespace EDA_SUMMARY including contents and datafiles;
drop tablespace EDA_EVENT including contents and datafiles;

重建2个表空间
重新执行imp,数据成功导入。

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/16396821/viewspace-683387/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2009-03-20

  • 博文量
    13
  • 访问量
    60279