Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖
1#
发表于 2011-10-18 21:22:06
ORA-01031: insufficient privileges,检查一下吧
2#
发表于 2011-10-19 09:43:44
应该是Oracle GoldenGate Delivery相关的数据库用户与权限。
在日志中可以看到进行了set current schema操作:
Setting current schema for DDL operation to [WPAS]. ---- set current schema后,并不意谓着具有这个schema的相应权限
-----------

SQL> create user testddl identified by test;

User created.

SQL> grant connect to testddl;

Grant succeeded.

SQL> conn testddl/test
Connected.

SQL> alter session set current_schema=test;

Session altered.

SQL> create table test.testxxx (id number);
create table test.testxxx (id number)
*
ERROR at line 1:
ORA-01031: insufficient privileges
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-6-1 21:53 , Processed in 0.049157 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569