Re: Where is the executable code of a trigger stored in the DBMS?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 12 Nov 2005 10:33:49 +0100
Message-ID: <4375b6fc$0$1621$626a14ce@news.free.fr>

"Leigh Williams" <leighwilliams_at_gmail.com> a écrit dans le message de news: 1131784629.548677.246620_at_g47g2000cwa.googlegroups.com...
| Where is the executable code of a trigger stored in the DBMS? My guess
| is the data database buffer (if present) or the data file?
|
| Can anyone confirm or correct me?
|
| Thanks in advance!
|

In the shared pool.
Source is in sys.trigger$ table (and in shared pool when loaded).

Regards
Michel Cadot Received on Sat Nov 12 2005 - 03:33:49 CST

This message: [ Message body ]
Next message: ORA600: "Re: ROWNUM & server performance"
Previous message: Leigh Williams: "Where is the executable code of a trigger stored in the DBMS?"
In reply to: Leigh Williams: "Where is the executable code of a trigger stored in the DBMS?"
Next in thread: jbmorla_at_gmail.com: "Re: Where is the executable code of a trigger stored in the DBMS?"
Reply: jbmorla_at_gmail.com: "Re: Where is the executable code of a trigger stored in the DBMS?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US