Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find when data was loaded into table

Re: How to find when data was loaded into table

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 30 Jul 2006 07:17:16 +0200
Message-ID: <73goc21kg5lvn15s8g4r1im19bvmfsrfh0@4ax.com>


On 29 Jul 2006 21:31:23 -0700, "ravi" <ravykanth_at_gmail.com> wrote:

>Hi all,
>Is there a way to find out when data was loaded into a table? I have
>read access to tables. I am using a client called rapid sql. Thanks in
>advance.

If the table has a separate column for this purpose, which is populated during load, it is possible.
Other than that you would need to find out the rowid, and use logminer to find out when it was inserted. The odds such a query fails are big.

--
Sybrand Bakker, Senior Oracle DBA
Received on Sun Jul 30 2006 - 00:17:16 CDT

Original text of this message

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