FAQ
Listers,

Oracle 8.1.7

I am looking for any whitepaper(s) that can
provide guidelines on the creation, use,
performance and limitations of triggers.

I need to create triggers on possibly 45 tables
for auditing purposes. The first draft
requirements document indicates denormalizing
data and generating data for null columns using
the triggers (yeah, bad ideas). I prefer to make
them as simple as possible and would like to have
the best arguments against doing it the way the
requirements suggest.

TIA,

Steve Haas

"Opinions, real or imagined, are mine."

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Haas
INET: steven.haas_at_snet.net

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

  • Yechiel Adar at Nov 13, 2002 at 1:03 pm
    In my browsing of the oracle docs I came across a sql statement call
    AUDITING.

    Why invent triggers when oracle does the work for you?

    Yechiel Adar
    Mehish
    ----- Original Message -----
    To: Multiple recipients of list ORACLE-L
    Sent: Friday, November 08, 2002 6:59 PM
    Listers,

    Oracle 8.1.7

    I am looking for any whitepaper(s) that can
    provide guidelines on the creation, use,
    performance and limitations of triggers.

    I need to create triggers on possibly 45 tables
    for auditing purposes. The first draft
    requirements document indicates denormalizing
    data and generating data for null columns using
    the triggers (yeah, bad ideas). I prefer to make
    them as simple as possible and would like to have
    the best arguments against doing it the way the
    requirements suggest.

    TIA,
    Steve Haas

    "Opinions, real or imagined, are mine."

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Haas
    INET: steven.haas_at_snet.net

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Yechiel Adar
    INET: adar76_at_inter.net.il

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Steven Haas at Nov 13, 2002 at 4:48 pm
    This is for FDA regulation compliance. The audit
    records need to show every change made to the
    source table in order of change.
    WHile audit the table will show who changed the
    record, it won't show what was changed.

    Steve

    Yechiel Adar wrote:
    In my browsing of the oracle docs I came across
    a sql statement call
    AUDITING.
    Why invent triggers when oracle does the work
    for you?

    Yechiel Adar
    Mehish
    ----- Original Message -----
    To: Multiple recipients of list ORACLE-L

    Sent: Friday, November 08, 2002 6:59 PM

    Listers,

    Oracle 8.1.7

    I am looking for any whitepaper(s) that can
    provide guidelines on the creation, use,
    performance and limitations of triggers.

    I need to create triggers on possibly 45 tables
    for auditing purposes. The first draft
    requirements document indicates denormalizing
    data and generating data for null columns using
    the triggers (yeah, bad ideas). I prefer to make
    them as simple as possible and would like to have
    the best arguments against doing it the way the
    requirements suggest.

    TIA,
    Steve Haas

    "Opinions, real or imagined, are mine."

    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: Steven Haas
    INET: steven.haas_at_snet.net

    Fat City Network Services -- 858-538-5051
    http://www.fatcity.com
    San Diego, California -- Mailing list
    and web hosting services

    To REMOVE yourself from this mailing list,
    send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling
    of 'ListGuru') and in
    the message BODY, include a line containing:
    UNSUB ORACLE-L
    (or the name of mailing list you want to be
    removed from). You may
    also send the HELP command for other
    information (like subscribing).

    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: Yechiel Adar
    INET: adar76_at_inter.net.il

    Fat City Network Services -- 858-538-5051
    http://www.fatcity.com
    San Diego, California -- Mailing list
    and web hosting services
    To REMOVE yourself from this mailing list, send
    an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling
    of 'ListGuru') and in
    the message BODY, include a line containing:
    UNSUB ORACLE-L
    (or the name of mailing list you want to be
    removed from). You may
    also send the HELP command for other
    information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Haas
    INET: steven.haas_at_snet.net

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • DENNIS WILLIAMS at Nov 13, 2002 at 5:09 pm
    Steven - If you need this level of detail, have you considered LogMiner?
    Just a thought.

    Dennis Williams
    DBA, 40%OCP

    Lifetouch, Inc.
    dwilliams_at_lifetouch.com

    -----Original Message-----
    Sent: Wednesday, November 13, 2002 10:49 AM
    To: Multiple recipients of list ORACLE-L

    This is for FDA regulation compliance. The audit
    records need to show every change made to the
    source table in order of change.
    WHile audit the table will show who changed the
    record, it won't show what was changed.

    Steve

    Yechiel Adar wrote:
    In my browsing of the oracle docs I came across
    a sql statement call
    AUDITING.
    Why invent triggers when oracle does the work
    for you?

    Yechiel Adar
    Mehish
    ----- Original Message -----
    To: Multiple recipients of list ORACLE-L

    Sent: Friday, November 08, 2002 6:59 PM

    Listers,

    Oracle 8.1.7

    I am looking for any whitepaper(s) that can
    provide guidelines on the creation, use,
    performance and limitations of triggers.

    I need to create triggers on possibly 45 tables
    for auditing purposes. The first draft
    requirements document indicates denormalizing
    data and generating data for null columns using
    the triggers (yeah, bad ideas). I prefer to make
    them as simple as possible and would like to have
    the best arguments against doing it the way the
    requirements suggest.

    TIA,
    Steve Haas

    "Opinions, real or imagined, are mine."

    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: Steven Haas
    INET: steven.haas_at_snet.net

    Fat City Network Services -- 858-538-5051
    http://www.fatcity.com
    San Diego, California -- Mailing list
    and web hosting services

    To REMOVE yourself from this mailing list,
    send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling
    of 'ListGuru') and in
    the message BODY, include a line containing:
    UNSUB ORACLE-L
    (or the name of mailing list you want to be
    removed from). You may
    also send the HELP command for other
    information (like subscribing).

    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: Yechiel Adar
    INET: adar76_at_inter.net.il

    Fat City Network Services -- 858-538-5051
    http://www.fatcity.com
    San Diego, California -- Mailing list
    and web hosting services
    To REMOVE yourself from this mailing list, send
    an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling
    of 'ListGuru') and in
    the message BODY, include a line containing:
    UNSUB ORACLE-L
    (or the name of mailing list you want to be
    removed from). You may
    also send the HELP command for other
    information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Haas
    INET: steven.haas_at_snet.net

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: DENNIS WILLIAMS
    INET: DWILLIAMS_at_LIFETOUCH.COM

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Lisa R. Clary at Nov 13, 2002 at 5:15 pm
    Since we are in the medical records business, we too have the same
    guideline. What we do, is create an exact table replica (we call it an
    archive table and it does not have constraints) to which before every insert
    and update on the primary table, sends the row data to the archive table. It
    stores the modifier and sysdate as well, so we have a complete history of
    revision. We don't allow deletes through users, only through dbas so that we
    can audit removals. Doing it this way eliminates that possibility of the
    fudge-factor on revisions/deletions. And when you are audited---it is a
    wonderful thing!

    lc

    -----Original Message-----
    Sent: Wednesday, November 13, 2002 11:49 AM
    To: Multiple recipients of list ORACLE-L

    This is for FDA regulation compliance. The audit
    records need to show every change made to the
    source table in order of change.
    WHile audit the table will show who changed the
    record, it won't show what was changed.

    Steve

    Yechiel Adar wrote:
    In my browsing of the oracle docs I came across
    a sql statement call
    AUDITING.
    Why invent triggers when oracle does the work
    for you?

    Yechiel Adar
    Mehish
    ----- Original Message -----
    To: Multiple recipients of list ORACLE-L

    Sent: Friday, November 08, 2002 6:59 PM

    Listers,

    Oracle 8.1.7

    I am looking for any whitepaper(s) that can
    provide guidelines on the creation, use,
    performance and limitations of triggers.

    I need to create triggers on possibly 45 tables
    for auditing purposes. The first draft
    requirements document indicates denormalizing
    data and generating data for null columns using
    the triggers (yeah, bad ideas). I prefer to make
    them as simple as possible and would like to have
    the best arguments against doing it the way the
    requirements suggest.

    TIA,
    Steve Haas

    "Opinions, real or imagined, are mine."

    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: Steven Haas
    INET: steven.haas_at_snet.net

    Fat City Network Services -- 858-538-5051
    http://www.fatcity.com
    San Diego, California -- Mailing list
    and web hosting services

    To REMOVE yourself from this mailing list,
    send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling
    of 'ListGuru') and in
    the message BODY, include a line containing:
    UNSUB ORACLE-L
    (or the name of mailing list you want to be
    removed from). You may
    also send the HELP command for other
    information (like subscribing).

    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: Yechiel Adar
    INET: adar76_at_inter.net.il

    Fat City Network Services -- 858-538-5051
    http://www.fatcity.com
    San Diego, California -- Mailing list
    and web hosting services
    To REMOVE yourself from this mailing list, send
    an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling
    of 'ListGuru') and in
    the message BODY, include a line containing:
    UNSUB ORACLE-L
    (or the name of mailing list you want to be
    removed from). You may
    also send the HELP command for other
    information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Haas
    INET: steven.haas_at_snet.net

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Lisa R. Clary
    INET: lisa_at_cog.ufl.edu

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • OraCop at Nov 13, 2002 at 5:54 pm
    We call them Journal tables.
    Great technique.

    OraCop

    "Lisa R. Clary" wrote:
    Since we are in the medical records business, we too
    have the same
    guideline. What we do, is create an exact table
    replica (we call it an
    archive table and it does not have constraints) to
    which before every insert
    and update on the primary table, sends the row data
    to the archive table. It
    stores the modifier and sysdate as well, so we have
    a complete history of
    revision. We don't allow deletes through users, only
    through dbas so that we
    can audit removals. Doing it this way eliminates
    that possibility of the
    fudge-factor on revisions/deletions. And when you
    are audited---it is a
    wonderful thing!

    lc

    -----Original Message-----
    Sent: Wednesday, November 13, 2002 11:49 AM
    To: Multiple recipients of list ORACLE-L


    This is for FDA regulation compliance. The audit
    records need to show every change made to the
    source table in order of change.
    WHile audit the table will show who changed the
    record, it won't show what was changed.

    Steve


    --- Yechiel Adar wrote:
    In my browsing of the oracle docs I came across
    a sql statement call
    AUDITING.
    Why invent triggers when oracle does the work
    for you?

    Yechiel Adar
    Mehish
    ----- Original Message -----
    To: Multiple recipients of list ORACLE-L

    Sent: Friday, November 08, 2002 6:59 PM

    Listers,

    Oracle 8.1.7

    I am looking for any whitepaper(s) that can
    provide guidelines on the creation, use,
    performance and limitations of triggers.

    I need to create triggers on possibly 45 tables
    for auditing purposes. The first draft
    requirements document indicates denormalizing
    data and generating data for null columns using
    the triggers (yeah, bad ideas). I prefer to make
    them as simple as possible and would like to have
    the best arguments against doing it the way the
    requirements suggest.

    TIA,
    Steve Haas

    "Opinions, real or imagined, are mine."

    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: Steven Haas
    INET: steven.haas_at_snet.net

    Fat City Network Services -- 858-538-5051
    http://www.fatcity.com
    San Diego, California -- Mailing list
    and web hosting services

    To REMOVE yourself from this mailing list,
    send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling
    of 'ListGuru') and in
    the message BODY, include a line containing:
    UNSUB ORACLE-L
    (or the name of mailing list you want to be
    removed from). You may
    also send the HELP command for other
    information (like subscribing).

    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: Yechiel Adar
    INET: adar76_at_inter.net.il

    Fat City Network Services -- 858-538-5051
    http://www.fatcity.com
    San Diego, California -- Mailing list
    and web hosting services
    To REMOVE yourself from this mailing list, send
    an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling
    of 'ListGuru') and in
    the message BODY, include a line containing:
    UNSUB ORACLE-L
    (or the name of mailing list you want to be
    removed from). You may
    also send the HELP command for other
    information (like subscribing).
    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: Steven Haas
    INET: steven.haas_at_snet.net

    Fat City Network Services -- 858-538-5051
    http://www.fatcity.com
    San Diego, California -- Mailing list and web
    hosting services
    To REMOVE yourself from this mailing list, send an
    E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of
    'ListGuru') and in
    the message BODY, include a line containing: UNSUB
    ORACLE-L
    (or the name of mailing list you want to be removed
    from). You may
    also send the HELP command for other information
    (like subscribing).

    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: Lisa R. Clary
    INET: lisa_at_cog.ufl.edu

    Fat City Network Services -- 858-538-5051
    http://www.fatcity.com
    San Diego, California -- Mailing list and web
    hosting services
    To REMOVE yourself from this mailing list, send an
    E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of
    'ListGuru') and in
    the message BODY, include a line containing: UNSUB
    ORACLE-L
    (or the name of mailing list you want to be removed
    from). You may
    also send the HELP command for other information
    (like subscribing).
    Do you Yahoo!?
    U2 on LAUNCH - Exclusive greatest hits videos
    http://launch.yahoo.com/u2

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: OraCop
    INET: oracop_at_yahoo.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Thomas Day at Nov 13, 2002 at 6:09 pm
    We have "journal" tables that mimic every table in our database. Every
    Insert, Update or Delete (we allow user deletes) gets the row written to
    the journal table along with a timestamp and the Oracle userid. Now we
    have to tie one Oracle userid to one and only one user.

    "Lisa R.
    Clary"
    @cog.ufl.edu> cc:
    Sent by: root Subject: RE: Whitepapers on Triggers

    11/13/2002
    12:15 PM
    Please
    respond to
    ORACLE-L

    Since we are in the medical records business, we too have the same
    guideline. What we do, is create an exact table replica (we call it an
    archive table and it does not have constraints) to which before every
    insert
    and update on the primary table, sends the row data to the archive table.
    It
    stores the modifier and sysdate as well, so we have a complete history of
    revision. We don't allow deletes through users, only through dbas so that
    we
    can audit removals. Doing it this way eliminates that possibility of the
    fudge-factor on revisions/deletions. And when you are audited---it is a
    wonderful thing!

    lc

    -----Original Message-----
    Sent: Wednesday, November 13, 2002 11:49 AM
    To: Multiple recipients of list ORACLE-L

    This is for FDA regulation compliance. The audit
    records need to show every change made to the
    source table in order of change.
    WHile audit the table will show who changed the
    record, it won't show what was changed.

    Steve

    Yechiel Adar wrote:
    In my browsing of the oracle docs I came across
    a sql statement call
    AUDITING.
    Why invent triggers when oracle does the work
    for you?

    Yechiel Adar
    Mehish
    ----- Original Message -----
    To: Multiple recipients of list ORACLE-L

    Sent: Friday, November 08, 2002 6:59 PM

    Listers,

    Oracle 8.1.7

    I am looking for any whitepaper(s) that can
    provide guidelines on the creation, use,
    performance and limitations of triggers.

    I need to create triggers on possibly 45 tables
    for auditing purposes. The first draft
    requirements document indicates denormalizing
    data and generating data for null columns using
    the triggers (yeah, bad ideas). I prefer to make
    them as simple as possible and would like to have
    the best arguments against doing it the way the
    requirements suggest.

    TIA,
    Steve Haas

    "Opinions, real or imagined, are mine."

    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: Steven Haas
    INET: steven.haas_at_snet.net

    Fat City Network Services -- 858-538-5051
    http://www.fatcity.com
    San Diego, California -- Mailing list
    and web hosting services

    To REMOVE yourself from this mailing list,
    send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling
    of 'ListGuru') and in
    the message BODY, include a line containing:
    UNSUB ORACLE-L
    (or the name of mailing list you want to be
    removed from). You may
    also send the HELP command for other
    information (like subscribing).

    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: Yechiel Adar
    INET: adar76_at_inter.net.il

    Fat City Network Services -- 858-538-5051
    http://www.fatcity.com
    San Diego, California -- Mailing list
    and web hosting services
    To REMOVE yourself from this mailing list, send
    an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling
    of 'ListGuru') and in
    the message BODY, include a line containing:
    UNSUB ORACLE-L
    (or the name of mailing list you want to be
    removed from). You may
    also send the HELP command for other
    information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Haas
    INET: steven.haas_at_snet.net

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Lisa R. Clary
    INET: lisa_at_cog.ufl.edu

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Thomas Day
    INET: tday6_at_csc.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Steven Haas at Nov 13, 2002 at 7:44 pm
    That is exactly what my design would be given the
    option. Thanks for concurring.

    I have also been asked if the trigger can fire
    off a pop-up box in the app to ask for a reason
    for change that needs to be in the audit record
    as well. Yeah, really... that's what they want.

    Another option suggested for tables with heavy
    updates is to record the full insert and only the
    column deltas on updates. Okay, lets compare all
    87 columns to see if the new value is the same as
    the old value. Just throw all kinds of junk in
    the trigger so it effects its performance.

    My origianl question was for any links to
    whitepapers on trigger devlopment.

    Thanks...

    Steve

    "Lisa R. Clary" wrote:
    Since we are in the medical records business,
    we too have the same
    guideline. What we do, is create an exact table
    replica (we call it an
    archive table and it does not have constraints)
    to which before every insert
    and update on the primary table, sends the row
    data to the archive table. It
    stores the modifier and sysdate as well, so we
    have a complete history of
    revision. We don't allow deletes through users,
    only through dbas so that we
    can audit removals. Doing it this way
    eliminates that possibility of the
    fudge-factor on revisions/deletions. And when
    you are audited---it is a
    wonderful thing!

    lc

    -----Original Message-----
    Sent: Wednesday, November 13, 2002 11:49 AM
    To: Multiple recipients of list ORACLE-L


    This is for FDA regulation compliance. The
    audit
    records need to show every change made to the
    source table in order of change.
    WHile audit the table will show who changed the
    record, it won't show what was changed.

    Steve


    --- Yechiel Adar wrote:
    In my browsing of the oracle docs I came across
    a sql statement call
    AUDITING.
    Why invent triggers when oracle does the work
    for you?

    Yechiel Adar
    Mehish
    ----- Original Message -----
    To: Multiple recipients of list ORACLE-L

    Sent: Friday, November 08, 2002 6:59 PM

    Listers,

    Oracle 8.1.7

    I am looking for any whitepaper(s) that can
    provide guidelines on the creation, use,
    performance and limitations of triggers.

    I need to create triggers on possibly 45 tables
    for auditing purposes. The first draft
    requirements document indicates
    denormalizing
    data and generating data for null columns using
    the triggers (yeah, bad ideas). I prefer
    to
    make
    them as simple as possible and would like
    to
    have
    the best arguments against doing it the way the
    requirements suggest.

    TIA,
    Steve Haas

    "Opinions, real or imagined, are mine."

    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: Steven Haas
    INET: steven.haas_at_snet.net

    Fat City Network Services --
    858-538-5051
    http://www.fatcity.com
    San Diego, California -- Mailing
    list
    and web hosting services

    To REMOVE yourself from this mailing list,
    send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT
    spelling
    of 'ListGuru') and in
    the message BODY, include a line
    containing:
    UNSUB ORACLE-L
    (or the name of mailing list you want to be
    removed from). You may
    also send the HELP command for other
    information (like subscribing).

    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: Yechiel Adar
    INET: adar76_at_inter.net.il

    Fat City Network Services -- 858-538-5051
    http://www.fatcity.com
    San Diego, California -- Mailing list
    and web hosting services
    To REMOVE yourself from this mailing list, send
    an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling
    of 'ListGuru') and in
    the message BODY, include a line containing:
    UNSUB ORACLE-L
    (or the name of mailing list you want to be
    removed from). You may
    also send the HELP command for other
    information (like subscribing).
    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: Steven Haas
    INET: steven.haas_at_snet.net

    Fat City Network Services -- 858-538-5051
    http://www.fatcity.com
    San Diego, California -- Mailing list
    and web hosting services
    To REMOVE yourself from this mailing list, send
    an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling
    of 'ListGuru') and in
    the message BODY, include a line containing:
    UNSUB ORACLE-L
    (or the name of mailing list you want to be
    removed from). You may
    also send the HELP command for other
    information (like subscribing).

    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: Lisa R. Clary
    INET: lisa_at_cog.ufl.edu

    Fat City Network Services -- 858-538-5051
    http://www.fatcity.com
    San Diego, California -- Mailing list
    and web hosting services
    To REMOVE yourself from this mailing list, send
    an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling
    of 'ListGuru') and in
    the message BODY, include a line containing:
    UNSUB ORACLE-L
    (or the name of mailing list you want to be
    removed from). You may
    also send the HELP command for other
    information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Steven Haas
    INET: steven.haas_at_snet.net

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedNov 8, '02 at 4:59p
activeNov 13, '02 at 7:44p
posts8
users6
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase