oracle816导入错误

最新推荐文章于 2025-04-16 10:03:44 发布

pinchw

最新推荐文章于 2025-04-16 10:03:44 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

分类专栏： ORACLE 文章标签： oracle compilation import object warnings exception

本文链接：https://blog.youkuaiyun.com/pinchw/article/details/5487388

ORACLE 专栏收录该内容

26 篇文章

订阅专栏

本文记录了在使用Oracle8i Enterprise Edition Release 8.1.6.0.0进行数据导入过程中遇到的三种常见错误：对象已存在、无法创建初始区及创建对象带有编译警告，并提供了详细的错误信息及解决建议。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Oracle8i Enterprise Edition Release 8.1.6.0.0 进行导出导入时，出现提示

导入语句：

imp "system/manager@test" file=Z:/backup.dmp log=Z:/fullimp.log full=y ignore=n COMMIT=Y

错误一：由于对象已存在，下列语句失败

IMP-00015: following statement failed because the object already exists:

Cause: Import failed to create an object because it already exists.

Action: Specify IGNORE=Y to ignore such errors and import rows even when tables are not created because they already exist.

错误二：IMP-00017: 由于ORACLE 错误1658，以下的语句失败

ORA-01658: 无法为表空间TSP_OUTPADM中的段创建INITIAL 区

IMP-00003: ORACLE 错误1658出现

IMP-00017:

Cause: Import failed to execute the statement from the export file because of an Oracle error.

Action: Look up the accompanying Oracle message in the ORA message chapters of this manual and take appropriate action.

IMP-00003:

Cause: Import encountered the referenced Oracle error.

Action: Look up the Oracle message in the ORA message chapters of this manual, and take appropriate action.

ORA-01658:
Cause: Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created.

Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with a smaller value for INITIAL

附：import相关日志:

IMP-00017: following statement failed with ORACLE error 1658:
"CREATE INDEX "IDX_CLINIC_BILL_ITEMS2"

ON "CLINIC_BILL_ITEMS" ("CLINIC_VISIT_ID" , "REQ_CLASS" )

PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 671244288 NEXT 335577088 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS"
" 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)

                                  TABLESPACE "TSP_OUTPADM" LOGGING"
           IMP-00003: ORACLE error 1658 encountered
           ORA-01658: unable to create INITIAL extent for segment in tablespace TSP_OUTPADM

错误三：

IMP-00041:警告: 创建的对象带有编译警告

Cause: The object in the SQL statement following this error was created with compilation errors. If this error occurred for a view, it is possible that the base table of the view was missing.

Action: This is a warning. The object may have to be recompiled before being used.

          IMP-00041: Warning: object created with compilation warnings
"CREATE TRIGGER "INSURANCE"."PRICE_ITEM_NAME_UPDATED""
"AFTER UPDATE OF "ITEM_NAME" ON "COMM"."PRICE_ITEM_NAME_DICT" FOR EACH ROW"
""
"begin"
" update insurance.price_vs_insur_FINAL"
"      set ITEM_NAME = :NEW.ITEM_NAME"
"      where item_class = :old.item_class and"
"            item_code = :old.item_code and"
"            ITEM_NAME = :OLD.ITEM_NAME ;"
"EXCEPTION"
" WHEN OTHERS THEN NULL;"
"end ;"