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

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@xxxxxxxxxxxxxxxxxxx
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

.

Relevant Pages

  • Re: Is there a kind of command history table in 10g?
    ... since I'm still in the state of experiencing a database I would like to ... know what mistakes I made some time ago. ... last 1000 statements for this sort of "oh crap" statement recall if I ...
    (comp.databases.oracle.server)
  • Re: Is there a kind of command history table in 10g?
    ... since I'm still in the state of experiencing a database I would like to ... Really big mistakes are in the alert log. ... The lesson being "you" may not be the only one using SYS commands. ...
    (comp.databases.oracle.server)
  • Is there a kind of command history table in 10g?
    ... 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... ...
    (comp.databases.oracle.server)
  • Re: Detail first? Or Big Picture?
    ... That's exactly the same example I use to support the idea the you have to ... foundations without changing the entire house, while mistakes in the roof ... itself knows exactly what it has created, redesigning the database ... fix given current constraints. ...
    (microsoft.public.vb.general.discussion)
  • Problems with Find Button and Linked Tables
    ... Access 2000 database - the record would simply not be found even though it ... we were advised to update the Jet Database engine using ... Recently we appear to be experiencing similar problems again although all ... Or is this patch or another patch now required? ...
    (microsoft.public.access.gettingstarted)