imp 导入报错

最新推荐文章于 2025-07-04 16:27:31 发布

转载最新推荐文章于 2025-07-04 16:27:31 发布 · 642 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/huakai201/p/10751936.html

文章标签：

#数据库

本文解决了在使用Oracle数据库进行数据导入导出时遇到的常见错误，如IMP-00013和IMP-00031等，通过给予用户DBA权限和指定正确的FROMUSER和TOUSER参数来解决这些问题。

imp user/passwd file=/data/oracle/oraclesetup/passwd.dmp
报错：
Export file created by EXPORT:V11.02.00 via conventional path
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully
解决办法：
给导入用户赋予dba权限
grant dba to neWbiupay;
报错：
Export file created by EXPORT:V11.02.00 via conventional path

Warning: the objects were exported by CASHIER, not by you

import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
export client uses ZHS16GBK character set (possible charset conversion)
IMP-00031: Must specify FULL=Y or provide FROMUSER/TOUSER or TABLES arguments
IMP-00000: Import terminated unsuccessfully
解决办法：
添加fromuser=cashier touser=newbiupay

转载于:https://www.cnblogs.com/huakai201/p/10751936.html