Re: Creating a Trigger Using Oracle Enterprise Manager

Paul Izzo wrote:
> I found the solution on my own but thanks for the tip Holger. OEM is a
> great tool to use in certain circumstances (this as one) It takes

I guess we can safely agree on this: OEM is a great tool in certain circumstances. Especially when I hadn't found out that the documentation on otn.oracle.com actually can be downloaded in one piece so the SQL Reference is always handy (on my notebook, on the intranet, at home), I used it to learn, or better lookup, the syntax for the job at hand.

However, I soon got into the habit of not letting it do the actual job, but use the 'show SQL' option, copy the sql, do some formatting, e.g. get rid of all those " around table and column names and then, after having learned a thing or two, putting the sql to work (sql*plus).

> several lines of code and writes them in the background for you
> (without typos) the only problem is sometimes figuring out what field
> is used as input for writting the SQL statement. I figured it out what
> I was doing wrong. I was inputting information into the condition
> field under the advanced tab rather than in the trigger body under the
> general tab.

>
> I know there are DBA's out there that feel like less of a DBA when
> using OEM because it makes some tasks easier. I on the other hand like

Nobody disposes a tool that makes a taks easier - at least nobody I know of. But as soon as you know what you're doing (this could be considered as the distinction between DBA and user ;-) ) I'm not sure if this still applies to creating a trigger.

> to be able to work with my database as quickly as possible with as
> little coding as possible. Am I a lesser DBA? If so then we should go
> back to the days of DOS and IRC.
>

I like to keep a documentation of what I did, because more often than not I'm going to repeat the same thing on the next server - and then I'll beat OEM everytime. But if OEM suits you, that's fine by me. However, asking for help without any precise information such as a skript is not going to be easy.

DOS and IRC? Those where the days, my friend!

Cheers,

Holger Received on Mon Jan 31 2005 - 08:24:35 CST