RE: How to locate who dropped a view using log miner?

From: Hillman, Alex <Alex.Hillman_at_usmint.treas.gov>
Date: Wed, 08 Aug 2001 08:49:02 -0700
Message-ID: <F001.0036455C.20010808084053@fatcity.com>

Strange how Oracle can make
complicated things right and very simple things very bad. Example - the same logminer. Looks like interface was done by brain dead people. I am not talking about the bugs. Also database assistant. This is a task for HS student - very simple GUI etc. and even after several reincarnations there are a lot of bugs.

Alex
Hillman

  <FONT face=Tahoma
  size=2>-----Original Message-----From: JOE TESTA   [mailto:JTESTA_at_longaberger.com]Sent: Wednesday, August 08, 2001   11:06 AMTo: Multiple recipients of list ORACLE-LSubject:   RE: How to locate who dropped a view using log miner?   Intentional or because you didnt have an up to date dictionary file.

  I'll be the last to defend oracle corp but that was version 1 of   logminer, before that you had basically nothing or pay for a 3rd party   tool.

  up thru 8.1.7 there is no support for DDL, never was and never will be in   8i.

  9i thats another story, i'm working with it now and hope to check out the   DDL this evening.

  joe

  joe-----Original Message-----Sent: Wednesday, August 08, 2001   4:11 AMTo: Multiple recipients of list ORACLE-LLife isn't   made any easier by the fact that it is apparentlya deliberate decision the   part of Oracle Corp to leavethe undo/redo for various dictionary tables   uninterpreted,so that SQl against TAB$ reads:delete from   UNKNOWN.objn:4where col[1] = hextoraw('c20301') ...I would   look only at the OBJ$ code, and set up thecolumn search section of log   miner to search forthe TYPE# column, specifying the value as per   thelist in $ORACLE_HOME/rdbms/admin/sql.bsqJonathan   LewisSeminars on getting the best out of OracleLast few places   available for Sept 10th/11thSee <A
  href="http://www.jlcomp.demon.co.uk/seminar.html">http://www.jlcomp.demon.co.uk/seminar.html-----Original   Message-----To: Multiple recipients of list ORACLE-L   <ORACLE-L_at_fatcity.com>Date: 08 August 2001 03:22|and you   might not find anything.||I'll reiterate, logminer in 8.1.5-.7 is   version 1.0, anything ofversion|1.0 is full of bugs(and logminer has   its own share), and does nothave|full functionality.||here is   the short version.||a DDL statement like drop table, does do DML   against underlyingtables|that end in $.||tab$, col$,   etc.||In an advanced logminer class i teach, you can SOMETIMES find   when a|table was dropped based on DML against the data dictionary but   NOT|always, why??||well chained/migrated rows is only noted as   operation = INTERNAL andyou|get NO redo or undo SQL.||I'm not   saying logminer is hard to use, but its a bit more than,||start   logminer and look for undo SQL in the v$logmnr_contents   view.||joe||--|Joe Testa|Performing Remote DBA   Services, need some backup DBA support?|For Sale: Oracle-dba.com domain,   its not going cheap but feel free to|ask :)|--|Please see the   official ORACLE-L FAQ: <A
  href="http://www.orafaq.com">http://www.orafaq.com|--|Author: Joe   Testa| INET: teci_at_the-testas.net||Fat City Network   Services    -- (858) 538-5051 FAX: (858) 538-5051|San   Diego, California        -- Public Internet   access /

  MailingLists|--------------------------------------------------------------------|To

REMOVE yourself from this mailing list, send an E-Mail message|to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in|the message BODY, include a line containing: UNSUB ORACLE-L|(or the name of mailing list you want to be removed from). You may|also send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com-- Author: Jonathan Lewis INET: jonathan_at_jlcomp.demon.co.ukFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing

  Lists--------------------------------------------------------------------To

REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Hillman, Alex INET:
Alex.Hillman_at_usmint.treas.govFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing

  Lists--------------------------------------------------------------------To