|
-
Table missing .. its belongs to APPS schema
its a Missing Table,, which is taking some value from "LOGON_TRIG" Trigger...
here am going to Post the Trigger:
DROP TRIGGER APPS.LOGON_TRIG;
CREATE OR REPLACE TRIGGER APPS.logon_trig
AFTER LOGON ON SCHEMA
BEGIN
INSERT INTO log_trig_table(user_id, log_date, action)
VALUES (USER, SYSDATE, 'Logging on');
END;
/
This Trigger Belongs to APPS schema.
I highlighted the Trigger affecting table,, that table is missing i hope,,
now if am running catprog.sql it may create those table, but if i ran that,, it will affect other triggers which created by my developers..(COUSTOM TRIGGERS)..
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|