expdp 导出报：ORA-39001:invalid argument value和ORA-00980: synonym translation is no longer valid

life is ftc

于 2020-03-30 10:03:54 发布

阅读量2.3k

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle

本文链接：https://blog.youkuaiyun.com/StringBuff/article/details/105192713

oracle 专栏收录该内容

9 篇文章

订阅专栏

Export: Release 11.2.0.4.0 - Production on Mon Mar 30 09:39:55 2020

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 options
ORA-39001: invalid argument value
ORA-00980: synonym translation is no longer valid

最近遇到expdp导出明明很常用的命令，却报错了，参数异常什么的，防不胜防。在网上搜到一条可用的sql(导出某个用户)，具体原因没有深究:加上最后一段：JOB_NAME=job_name

expdp 用户/密码  parallel=2 DIRECTORY=DATA_PUMP_DIR DUMPFILE=xxx.dmp logfile=xxxx.log schemas=用户名 JOB_NAME=job_name