Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Can't create a trigger on table i created
Hi,
I'm very new to Oracle so bare with me .
I'm using Personal Oracle 8.0 on NT.
I've logged into my conf database using
connect internal/oracle_at_conf;
I've created a table named inventory .
When i attempt to create a trigger with the below coide in SQL Plus
CREATE OR REPLACE TRIGGER Create_Awf_Job
BEFORE UPDATE ON Inventory
call CreateJob('http://johnh-p2-400/createnewjob.asp',
'0XCF804840115111d48C6100104B71BD07', '0xF50517327A8E11D4A6CE00104B8D17A
2', 50, 10)
I get the following error.
ORA-04089: cannot create triggers on objects owned by SYS
How can i get the trigger created on the table?. I Think Internal is a user name created when i installed the product.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Aug 25 2000 - 11:31:51 CDT