在嘗試創(chuàng)建名為ghazal_current_bef_upd_row的觸發(fā)器時(shí)：

create trigger ghazal_current_bef_upd_row

before update on ghazal_current

for each row

when (new.Rating < old.Rating)

begin

insert into ghazal_current_audit

(GhazalName,Old_Rating,New_Rating)

values

(:old.GhazalName,:old.Rating,:new.Rating);

end;

我收到以下錯(cuò)誤：

Error report:

ORA-04089: cannot create triggers on objects owned by SYS

04089. 00000 - "cannot create triggers on objects owned by SYS"

*Cause: An attempt was made to create a trigger on an object owned by SYS.

*Action: Do not create triggers on objects owned by SYS.

名為ghazals_current和ghazal_current_audit的表都是由SYS創(chuàng)建的.為什么我不能在SYS創(chuàng)建的表上創(chuàng)建觸發(fā)器.

總結(jié)

以上是生活随笔為你收集整理的oracle sys连接不上,oracle – 为什么我不能在SYS拥有的对象上创建触发器？的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。