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 -> owner of transactions

owner of transactions

From: Andrea <netsecurity_at_tiscali.it>
Date: 12 Apr 2007 06:17:57 -0700
Message-ID: <1176383877.347257.162910@q75g2000hsh.googlegroups.com> 





Hi,


i've read on oracle library that is possible to find when the rows are
inserted, through SCN:



Example..


SELECT SCN_TO_TIMESTAMP(ORA_ROWSCN) FROM FOO;


SCN_TO_TIMESTAMP(ORA_ROWSCN)




11-APR-07 15:29:47,000000000
11-APR-07 15:29:47,000000000
10-APR-07 15:20:47,000000000






is possible knows also which user has inserted the rows or which user
had last access on the table?



thanks


bye


Andrea
Received on Thu Apr 12 2007 - 08:17:57 CDT












Original text of this message













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