C:\Documents and Settings\Administrator>exp xhh/xhh123 file=c:\xhh.dmp full=y
Export: Release 11.2.0.1.0 - Production on 星期一 10月 15 10:52:22 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
EXP-00056: 遇到 ORACLE 错误 1045
ORA-01045: user XHH lacks CREATE SESSION privilege; logon denied
用户名:
口令:
当我们执行exp时,oracle提示用户缺少create session权限的错误信息:
使用grant 授予用户create session 和resource权限
SQL> grant create session,resource to xhh;
授权成功。
SQL>
授权后,再次执行exp成功:
C:\Documents and Settings\Administrator>exp xhh/xhh123 file=c:\xhh.dmp full=y
Export: Release 11.2.0.1.0 - Production on 星期一 10月 15 10:53:54 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
EXP-00023: 必须是 DBA 才能执行完整数据库或表空间导出操作
(2)U(用户), 或 (3)T(表): (2)U >
---------The End
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8541492/viewspace-746421/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8541492/viewspace-746421/