记录一次Oracle导入数据库失败的解决办法，最终报错：UDI-04045、ORA-04045、ORA-01775...

大西瓜大哥

已于 2023-09-20 17:05:58 修改

阅读量568

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle 文章标签：数据库 oracle

于 2022-09-14 20:51:00 首次发布

本文链接：https://blog.youkuaiyun.com/silgen/article/details/133011186

本文详细记录了解决Oracle数据库在导入数据过程中因undo表空间不足引发的错误，包括识别问题、调整undo表空间、脚本操作及最终成功导入的过程。

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

费了很大的工夫，终于解决了。做个记录。

********************************************************************************创建完成用户及表空间后，导入数据库，出现如下问题：********************************************************************************

[oracle@ufdb165 bin]$ ./impdp cwy_init0914/cwy_123456789@ufgovdb1 directory=DATA_PUMP_DIR dumpfile=cwy_init_0902.dmp REMAP_SCHEMA=cwy_init:cwy_init0914 transform=segment_attributes:n logfile= imp_cwy_init_0914.log

Import: Release 11.2.0.4.0 - Production on Wed Sep 14 17:11:38 2022

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsORA-31626: job does not existORA-31637: cannot create job SYS_IMPORT_FULL_01 for user CWY_INIT0914ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95ORA-06512: at "SYS.KUPV$FT_INT", line 798ORA-39080: failed to create queues "KUPC$C_1_20220914171138" and "KUPC$S_1_20220914171138" for Data Pump jobORA-06512: at "SYS.DBMS_SYS_ERROR", line 95ORA-06512: at "SYS.KUPC$QUE_INT", line 1534ORA-00604: error occurred at recursive SQL level 2ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

******************************************************************************************解决办法：参考https://blog.youkuaiyun.com/u011199063/article/details/54138871/******************************************************************************************
SQL> conn / as sysdba
SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql
SQL> @?/rdbm