互联网服务数据库

数据库触发器报错

数据库做了个迁移,现在after类型触发器有问题,报-989的错误显示全部

数据库做了个迁移,现在after类型触发器有问题,报-989的错误

收起
参与11

查看其它 3 个回答Scott_jin的回答

Scott_jinScott_jin数据库管理员环境

SQL0909N  The object has been deleted.

Explanation:

The application program has either (1) dropped a table and then

attempted to access it, or (2) dropped an index and then tried to access

its object table using that index.

User response:

The logic of the application program must be corrected such that it does

not attempt to access or use an object after it has been dropped.

Dropping indexes within an application program is especially hazardous,

because there is no way of determining whether or not the plan that has

been generated for the application (by BIND or REBIND) actually uses a

particular index for access to its object table.

sqlcode: -909

sqlstate: 57007

互联网服务 · 2016-08-05
浏览1346

回答者

Scott_jin
数据库管理员环境

Scott_jin 最近回答过的问题

回答状态

  • 发布时间:2016-08-05
  • 关注会员:4 人
  • 回答浏览:1346
  • X社区推广