Re: Operation Log

From: Stan <stan0074_at_yahoo.com>
Date: Sat, 22 Jun 2002 17:58:12 GMT
Message-ID: <3D14BBEF.70309@yahoo.com>

Hi Donato,

As far as monitoring DML activities of a user on a database, you could look into enabling audit trails. More info can be found at http://tahiti.oracle.com.

Can i return to a state of a database? yes *flashback queries* would do that for you, but not in 8.0.5 as this feature is only available from oracle 9i releases.

hth,
-Stan

Donato Verrastro wrote:

> Can I know all the operations that an user has been done on the database?
> Can I return to a particular situation of the database?
> For example if an user ha been done 3 queries:
> a delete query, an insert query and then an update query with commit. Can I
> return after the insert query?
> where can I found any documentation about this question?
> I work with Oracle 8.0.5.
> Thank you
> Donato Verrastro
>
>
>
Received on Sat Jun 22 2002 - 12:58:12 CDT