Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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|--------------------------------------------------------------------|ToREMOVE 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: http://www.orafaq.com--
Lists--------------------------------------------------------------------ToREMOVE 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:
Lists--------------------------------------------------------------------ToREMOVE 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). Received on Wed Aug 08 2001 - 09:33:57 CDT