ORA-31633

admin

1.用expdp导出数据时报错：

1. Export: Release 12.1.0.2.0 - Production on Fri Jul 10 21:44:17 2020
   
2. 
   
3. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
   
4. 
   
5. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
   
6. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
   
7. Advanced Analytics and Real Application Testing options
   
8. ORA-31626: job does not exist
   
9. ORA-31633: unable to create master table "SYS.EXP0709"
   
10. ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
    
11. ORA-06512: at "SYS.KUPV$FT", line 1048
    
12. ORA-00955: name is already used by an existing object

复制代码

这是上次的job还在，drop掉就好了
select * from dba_datapump_jobs;
把里面得not running得表drop掉