ORA-31664: unable to construct unique job name when defaulted

[oracle@dump]$ expdp content=all directory=dump dumpfile=hh.dmp logfile=hh.log full=y

 

Export: Release 10.2.0.1.0 - Production on Tuesday, 04 December, 2012 9:09:50

 

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

 

Username: system

Password:

 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

ORA-31634: job already exists

ORA-31664: unable to construct unique job name when defaulted

 

[oracle@dump]$oerr ora 31664

31664, 00000, "unable to construct unique job name when defaulted"

// *Cause:  The job name was defaulted, and the name creation algorithm

//          was unable to find a unique job name for this schema where the

//          table name (for the master table) didn't already exist.

// *Action: Specify a job name to use or delete some of the existing tables

//          causing the name conflicts.

 

查看EXPORT備份時產生表格：

SYSTEM.SYS_EXPORT_FULL1...99.

已產生99個，無法再產生備份表格。

 

Drop相應SYS_EXPORT_FULL1…99的table，再次備份OK.

 

 

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

转载于:http://blog.itpub.net/7836221/viewspace-750487/