Urgent! tables are dropped

[dragon99]

Hi, all
I have a urgent quesion, I just find out that some of the tables are missing in my production database. Is there any way I can easily find out who did it? By the way, I do not have triggers on the tables. Any input would be appreciated. Thanks a million!

Dragon

[nirasha]

Logminer???? I have not used it yet, and not sure it works with DDL.

Good luck,
Nirasha

[dragon99]

Sorry, my db is 8.1.5E.E. logminer starts with 8.1.6? I guess

[chrisrlong]

Per jmodic, you can still do it...

http://www.dbasupport.com/forums/sho...?threadid=9215

HTH,

- Chris

[jmodic]

Originally posted by dragon99
Sorry, my db is 8.1.5E.E. logminer starts with 8.1.6? I guess

Logminer was introduced in 8.1.5, so you are ready to go....

[kmesser]

logminer was introduced with 8i, but will work on any Oracle 8 or newer database.

[pangul]

just wondering does logminer records DDL's as well??

[jdorlon]

Yes I believe it does.

[jmodic]

Well, not directly, only indirectly. When executing DDLs, database dictionary tables are updated, inserted or deleted and those dictionary DMLs are logged. So you actually won't find any 'DROP TABLE ...' in your log miner output, but you'll find "INSERT INTO sys.obj$ (obj#, dataobj#, owner#, name, ...) VALUES(...)"
in the SQL_REDO of the logminer output. So you'll be looking for the above statements where column NAME will reference your dropped table name.