Re: Can't create a trigger on table i created

Never do anything of your own in the SYS schema. Do it in SCOTT or a user you created.

Yong Huang

<harkinj_at_my-deja.com> wrote in message news:8o671m$v0b$1_at_nnrp1.deja.com...
> 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 - 12:28:07 CDT