Re: Last access in table

2003-01-31 Thread Adriano Freire
Title: RE: Last access in table Ok Jerry thanks a lot... Adriano - Original Message - From: Whittle Jerome Contr NCI To: Multiple recipients of list ORACLE-L Sent: Thursday, January 30, 2003 5:34 PM Subject: RE: Last access in table Adriano, To see what

Last access in table

2003-01-30 Thread Adriano Freire
DBA's, How can i see the last(date) access(DML) in a table? Thanks Adriano

RE: Last access in table

2003-01-30 Thread Whittle Jerome Contr NCI
Title: RE: Last access in table Adriano, To see what happens from now on, turn on auditing for that table. To see what has already happened in the table, you aren't going to have too much luck unless auditing is already on. You could try running the statement below. It won't actually show