You can use LogMiner utility for reading log file content. Mahir M. Quluzade | Oracle Blog: Oracle Database Administration - How to use Oracle LogMiner?
I think you can find only DROP TABLE .. command in logfile no data of table
If Recycle bin is not purged, then you can see table in recycle bin.
Please Check : Managing Tables
Mahir M. Quluzade
Of course you can see the table data. You just need all log files that manipulated the data. Using LogMiner to Analyze Redo Log Files
If you can flashback the table to before drop, that is easier of course.
Of course you are right ! and also i never used logiminer utility.
I am coming to your point as well as i remember previous thread.
When i google , i can get some wrong links. Could you please suggest best link to follow for logminer ?
MahirM.Quluzade he has explained in video using sQL developer tool but i am not using SQL developer tool as well as some confusions.
Can you provide better link ?
logminer has a steep learning curve, but the regular docs should be able to get you started. Offhand I wouldn't know any links, you can search as well as I. It is the hard way to get data back compared to others. Is getting data back your goal?
As a DBA, the first rule is to not lose data. There are so many ways to protect the data, all require some work, some are so obvious they should be part of normal routines. Beyond that, the smart DBA needs to know what the users expect, and what they don't expect that you know about.
So that means: Run in archivelog mode, and have tested recovery procedures; use appropriate flashback configuration; use logical backups (to restore from certain user errors quickly); and understand all the tools at your disposal. Logminer is usually a last resort, but it can be handy for certain specific problems like how to undo a botched update.
Not sure what you mean about a post under your user_id, I'm not an admin. Some bugs in the forum software have bamboozled people into thinking their posts are not visible when they are, see discussions in the Community Forum.
Thanks for your suggestion. Is getting data back your goal ?
I dont understand what do you mean. Just i want check dropped object information in redo log files. - Self learning !
Just we hold this task . I have started to practice. Too much confusion and Some Emergency work is here .
Anyhow , after a week , ill post my reply. Thanks ..