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

SRE实战 互联网时代守护先锋,助力企业售后服务体系运筹帷幄!一键直达领取阿里云限量特价优惠。

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

扫码关注我们
微信号:SRE实战
拒绝背锅 运筹帷幄