Re: Is there a kind of command history table in 10g?

From: Helma <helma.vinke_at_hotmail.com>
Date: Thu, 30 Aug 2007 08:16:14 -0700
Message-ID: <1188486974.327438.36110@22g2000hsm.googlegroups.com>

On Aug 30, 5:02 pm, "Marc F. Neininger"
<doesnt.ex..._at_champagnierle.de> wrote:
> Hello,
>
> since I'm still in the state of experiencing a database I would like to
> know what mistakes I made some time ago. And as I learned that in Oracle
> everything is a table or within one I'm wondering if there is kind of
> history table for my SYS commands...
>
> TIA
>
> Marc

You can audit users. (see conceptsguide). When this is configured, audit trails will be in the table SYS.AUD$ , or in OS files.

Alternatively, I make a personal file ( e.g. notepad file) and write down the things i do to solve a problem. This helps me to reverse my actions if needed, to have an overview for others of what i tried to solve the problem, and to provide fuel for my personal 'nice-to-know' knowledgebase.

H. Received on Thu Aug 30 2007 - 10:16:14 CDT