Hi,

Could someone pls help me find out the user name who dropped some of the tables from an oracle schema. We have not yet shutdown the db for recovery. This is just to find out how nearly 400 tables got dropped and the complete information about the session which dropped them.We are running in noarchivelog mode.

thanking you,
Parijat Paul