费了很大的工夫,终于解决了。做个记录。
********************************************************************************创建完成用户及表空间后,导入数据库,出现如下问题:********************************************************************************
[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
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
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