Have you thought of writing a trigger to capture the drops. See chapter 13 Of the
Application Developers Guide Fundamentals
Ian
-Original Message-
Sent: Tuesday, August 07, 2001 8:11 PM
To: Multiple recipients of list ORACLE-L
Hi listers,
I know most of you will advice me to turn
Life isn't made any easier by the fact that it is apparently
a deliberate decision the part of Oracle Corp to leave
the undo/redo for various dictionary tables uninterpreted,
so that SQl against TAB$ reads:
delete from UNKNOWN.objn:4
where col[1] = hextoraw('c20301') ...
I would look only at
Can you elaborate a little bit more please.
Alex Hillman
-Original Message-
Sent: Wednesday, August 08, 2001 4:11 AM
To: Multiple recipients of list ORACLE-L
Life isn't made any easier by the fact that it is apparently
a deliberate decision the part of Oracle Corp to leave
the
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.
Do you mean the bit about OBJ$ ?
Anything you create in the database will have its
name and type stored in OBJ$. This is defined in
the database creation script sql.bsq, which happens
to include the list of types and codes, as follows:
/* 1 = INDEX, 2 = TABLE, 3 = CLUSTER, 4 = VIEW, 5 =
after several reincarnations there are a lot of
bugs.
Alex
Hillman
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]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
Sure I have. The thing is, what can you do when you get someone else's databases
which are in 8.0.6 and had no auditing when something happened ?
- BTW I would like to know what you DBAs do when you experience something like this. -
To me, blaming others for not doing what it is supposed to is
Apparently intentional - the file was newly generated,
and when I called it in to Oracle they told me it
was deliberate. Off-hand I think it was
tab$, col$, ind$, icol$ that were excluded
from the normal display.
Jonathan Lewis
Seminars on getting the best out of Oracle
Last few places
Sure I have. The thing is, what can you do when you get someone else's databases
which are in 8.0.6 and had no auditing when something happened ?
- BTW I would like to know what you DBAs do when you experience something like this. -
To me, blaming others for not doing what it is supposed to
Can you elaborate a little more about columns?
TIA
[EMAIL PROTECTED] 08/08/01 19:53 PM
Do you mean the bit about OBJ$ ?
Anything you create in the database will have its
name and type stored in OBJ$. This is defined in
the database creation script sql.bsq, which happens
to include the list
you're making things way too hard.
logminer is in its infancy at best up thru 8.1.7(its a tad bit better in
9i
shameless plug
and if all goes well, i'll be doing a talk on it at IOUG 2002
/shameless plug
How do you handle when things go south and only internal shows as the
operation, you're
Title: RE: How to locate who dropped a view using log miner?
take a look at the
sys.ind$ table for indexes
sys.view$ for views
sys.source$ for stored procedures
HTH
Nick Wagner
Quest Software
www.quest.com
-Original Message-
From: Mario Alberto Ramos Arellano [mailto:[EMAIL
Title: RE: How to locate who dropped a view using log miner?
Hi
I dont
find any records in v$logmnr_contents even if i dropped tables /views. Should i
enable any parameter and restart db to get records.
srinivas
-Original Message-From: Nick Wagner
[mailto:[EMAIL PROTECTED
13 matches
Mail list logo