报错信息:
EXP-00023: must be a DBA to do Full Database export
(2)U(sers), or (3)T(ables): (2)U >
EXP-00030: Unexpected End-Of-File encountered while reading input
(2)U(sers), or (3)T(ables): (2)U >
EXP-00030: Unexpected End-Of-File encountered while reading input
状况描述:
使用非sys用户逻辑备份全库时出现EXP-00023错误(注:备份全库 参数full=y)
原因分析:
此非sys用户没有权限备份全库,需要分配备份全库的权限给该用户
解决思路:
只要用DBA权限使用grant语句给该用户赋予相应的权限就OK啦!
处理方法:
SQL> grant connect to rman;
Grant succeeded.
SQL> grant EXP_FULL_DATABASE to rman;
Grant succeeded.
--------------------------------------------------------------------------------------------
版权所有,转载请注明作者及原文链接,否则追究法律责任!
QQ: 584307876
作者: Seven
原文链接: http://blog.csdn.net/sunjiapeng/article/details/8315442
邮箱: seven_ginna@foxmail.com