Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to find when data was loaded into table
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 DBAReceived on Sun Jul 30 2006 - 00:17:16 CDT