Leeyun的gravatar头像
Leeyun 2017-04-18 10:09:33

SQL文件打开执行的时候总是会出现问题,无法全部通过,触发器无法创建?

你好,我在用您分享的源码的时候,.SQL文件打开执行的时候总是会出现问题,无法全部通过,触发器无法创建,请问一下这是什么原因,怎么解决呢?谢谢。

在行: 20 上开始执行命令时出错 -
Insert into AUTH.ROLERIGHT (RRID,FUNID,ROLEID) values (24,3,3)
错误位于命令行: 20 列: 18
错误报告 -
SQL 错误: ORA-04098: 触发器 'AUTH.tib_roleright' 无效且未通过重新验证
04098. 00000 -  "trigger '%s.%s' is invalid and failed re-validation"
*Cause:    A trigger was attempted to be retrieved for execution and was
           found to be invalid.  This also means that compilation/authorization
           failed for the trigger.
*Action:   Options are to resolve the compilation/authorization errors,
           disable the trigger, or drop the trigger.

在行: 21 上开始执行命令时出错 -
Insert into AUTH.ROLERIGHT (RRID,FUNID,ROLEID) values (25,1,21)
错误位于命令行: 21 列: 18
错误报告 -
SQL 错误: ORA-04098: 触发器 'AUTH.tib_roleright' 无效且未通过重新验证
04098. 00000 -  "trigger '%s.%s' is invalid and failed re-validation"
*Cause:    A trigger was attempted to be retrieved for execution and was
           found to be invalid.  This also means that compilation/authorization
           failed for the trigger.
*Action:   Options are to resolve the compilation/authorization errors,
           disable the trigger, or drop the trigger.

在行: 22 上开始执行命令时出错 -
Insert into AUTH.ROLERIGHT (RRID,FUNID,ROLEID) values (26,4,21)
错误位于命令行: 22 列: 18
错误报告 -
SQL 错误: ORA-04098: 触发器 'AUTH.tib_roleright' 无效且未通过重新验证
04098. 00000 -  "trigger '%s.%s' is invalid and failed re-validation"
*Cause:    A trigger was attempted to be retrieved for execution and was
           found to be invalid.  This also means that compilation/authorization
           failed for the trigger.
*Action:   Options are to resolve the compilation/authorization errors,
           disable the trigger, or drop the trigger.
在行: 23 上开始执行命令时出错 -
Insert into AUTH.ROLERIGHT (RRID,FUNID,ROLEID) values (21,1,1)
错误位于命令行: 23 列: 18
错误报告 -
SQL 错误: ORA-04098: 触发器 'AUTH.tib_roleright' 无效且未通过重新验证
04098. 00000 -  "trigger '%s.%s' is invalid and failed re-validation"
*Cause:    A trigger was attempted to be retrieved for execution and was
           found to be invalid.  This also means that compilation/authorization
           failed for the trigger.

所有回答列表(1)
welapple的gravatar头像
welapple  LV4 2017年4月20日

权限,看看权限!

顶部 客服 微信二维码 底部
>扫描二维码关注最代码为好友扫描二维码关注最代码为好友