FAQ
Anyone know off hand where I can find the date a row was created?

Keith M. Cutler
Oracle 8i Certified DBA
keith_at_etix.com

www.etix.com
919.782.5010 office
919.782.7727 fax

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.

Search Discussions

  • Mogens Nørgaard at Feb 15, 2004 at 9:10 pm
    A block dump might reveal the SCN of the latest update of a row, but I
    don't think what you're asking is possible. So an insert trigger and a
    date column might be the way to go.

    Mogens

    Keith M Cutler wrote:
    Anyone know off hand where I can find the date a row was created?

    Keith M. Cutler
    Oracle 8i Certified DBA
    keith_at_etix.com
    www.etix.com
    919.782.5010 office
    919.782.7727 fax


    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Powell, Mark D at Feb 16, 2004 at 3:40 pm
    Keith, You might find the following article of interest.

    Is there a way to get the Date/Time when a row was last updated?

    http://www.jlcomp.demon.co.uk/faq/mod_time.html

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Keith M Cutler
    Sent: Sunday, February 15, 2004 1:11 PM
    To: oracle-l_at_freelists.org
    Subject: Row Creation

    Anyone know off hand where I can find the date a row was created?

    Keith M. Cutler
    Oracle 8i Certified DBA
    keith_at_etix.com

    www.etix.com
    919.782.5010 office
    919.782.7727 fax

    ----------------------------------------------------------------

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/

    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org

    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
  • Niall Litchfield at Feb 16, 2004 at 3:47 pm
    5 minutes after the time that your user told you prior to doing a PITR. :(=
    =20
    Niall
    -----Original Message-----
    From: mln_at_miracleas.dk=20
    Sent: 15 February 2004 21:10
    To: mln_at_miracleas.dk; oracle-l_at_freelists.org
    Subject: Re: Row Creation
    =20
    =20
    A block dump might reveal the SCN of the latest update of a=20
    row, but I=20
    don't think what you're asking is possible. So an insert=20
    trigger and a=20
    date column might be the way to go.
    =20
    Mogens
    =20
    Keith M Cutler wrote:
    =20
    Anyone know off hand where I can find the date a row was created?

    Keith M. Cutler
    Oracle 8i Certified DBA
    keith_at_etix.com
    www.etix.com
    919.782.5010 office
    919.782.7727 fax


    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    =20
    =20
    =20
    =20
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    =20
    =20
    This email contains information intended for
    the addressee only. It may be confidential
    and may be the subject of legal and/or
    professional privilege. Any dissemination,
    distribution, copyright or use of this
    communication without prior permission of
    the sender is strictly prohibited.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedFeb 15, '04 at 6:11p
activeFeb 16, '04 at 3:47p
posts4
users4
websiteoracle.com

People

Translate

site design / logo © 2021 Grokbase