DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: What causes a trigger to become disabled?

  1. #1
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    What causes a trigger to become disabled?

    What causes a trigger to become disabled?

    Hello,
    How is it possible for a trigger to appear as disabled (in user_triggers) without explicity issuing ALTER TRIGGER ..DISABLE?

    We exported the db to a client site, checked for invalid objects (there were none) and now a week later mysteriously proceses have stopped working which we have found is related to triggers being disabled.

    Here's what I checked.
    >Ran a simple testcase with a trigger that inserts values into specific columns of a table. Dropped one of the columns that the trigger inserts into. The trigger shows as invalid but is still enabled
    >Droped a table that the trigger inserts into. The trigger shows as invalid but is still enabled.

    I also thought that perhaps the trigger may not have got enabled on import however these processes have been working fine since the import
    until just the past day. The import occured over a week ago.

    We are 90140 on win 2k

    tks for any suggestion
    I'm stmontgo and I approve of this message

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    A trigger can become invalid if you alter one of the dependant objects (table, function call in the trigger, etc).
    Jeff Hunter

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    marist89 tks,

    invalid i understand, but disabled....that is the question, what could cause the trigget to become 'DISABLED'?

    tks


    teve
    I'm stmontgo and I approve of this message

  4. #4
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    check when the trigger got disabled .

    select object_name, , last_ddl_time , timestamp from all_objects where object_type='TRIGGER' ;

    if u have applied any patch on the database just check if
    system_enabled_trigger=FALSE is set or not ?

    do u use materialised views for replication ??
    siva prakash
    DBA

  5. #5
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    tks prakashs43

    check when the trigger got disabled .

    select object_name, , last_ddl_time , timestamp from all_objects where object_type='TRIGGER' ;
    ....dooh, what a rookie mistake, i guess I should have checked that before I renabled the trigger

    if u have applied any patch on the database just check if
    system_enabled_trigger=FALSE is set or not ?
    ...no not the case

    do u use materialised views for replication ??
    >no
    I'm stmontgo and I approve of this message

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width