Re: Oracle Database Appliance – /u01 filling up

Posted by Phindile on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Oracle-Database-Appliance-u01-filling-up-tp2573p4281.html

Hi Erman,

Are you familiar with triggers, I have two schemas/users. HR_USER owns a table called DUMMY_PERSON and HRPERSAL_USER owns a table called DUMMY_PER_GEN_DET.

I'm trying to create a trigger that will update table DUMMY_PERSON whenever there's a new insert in a column called PERSALNO on table DUMMY_PER_GEN_DET.

I'm getting an error which says table or view doesn't exist, but I granted HRPERSAL_USER update and insert privileges on table DUMMY_PERSON.

This is my code:
create or replace TRIGGER DUMMY_HRPERSAL_TRIGGER AFTER INSERT OR UPDATE ON DUMMY_PER_GEN_DET FOR EACH ROW WHEN (new.R_INDICATOR = '0')
BEGIN INSERT INTO DUMMY_PERSON (PERSALNO,COL_SEQ) VALUES (:new.PERSALNO,DUMMY_HRPERSAL_SEQ.NEXTVAL); END;

Is there some which maybe I didn't include in my code?
Thanks