首页 > 其他 > 详细

imp 导入报错

时间:2019-04-22 18:58:54      阅读:178      评论:0      收藏:0      [点我收藏+]

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

imp 导入报错

原文:https://www.cnblogs.com/huakai201/p/10751936.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!