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 -> Re: Is there a kind of command history table in 10g?

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

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Thu, 30 Aug 2007 10:16:06 -0500
Message-ID: <46d6d32b$0$16373$88260bb3@free.teranews.com>


Marc F. Neininger 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

The short answer is: No

One could write some system trigger which logs entries to a table whenever a DDL command is issued. But out of the box, the functionality you describe is not available.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com
Received on Thu Aug 30 2007 - 10:16:06 CDT

Original text of this message

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