ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-31664: unable to construct unique job name when defaulted

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

原创 Linux操作系统 作者:ginni_hua 时间:2012-12-04 09:26:18 0 删除 编辑

[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_FULL199table,再次備份OK.

 

 

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

请登录后发表评论 登录
全部评论

注册时间:2008-03-20

  • 博文量
    172
  • 访问量
    361694