From JTESTA@longaberger.com Wed, 08 Aug 2001 07:33:57 -0700 From: "JOE TESTA" Date: Wed, 08 Aug 2001 07:33:57 -0700 Subject: RE: How to locate who dropped a view using log miner? Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 http://www.jlcomp.demon.co.uk/seminar.html-----Original Message-----To: Multiple recipients of list ORACLE-L 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: http://www.orafaq.com|--|Author: Joe Testa|  INET: teci@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@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: http://www.orafaq.com-- Author: Jonathan Lewis  INET: jonathan@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@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@usmint.treas.govFat 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@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).