Tables missing after ALTER DATABASE CHARACTERSET
The charactersets in one of my databases was changed from UTF8 to AL32UTF8 to support some XML data. The change was performed by someone else by issuing 'ALTER DATABASE CHARACTER SET AL32UTF8; ' . There were no errors and the database came back up , but after some time I noticed that some of the tables that had CLOB datatype columns are missing - meaning the tables are totally gone. I am not sure if this is related to the characterset change - I hope it is not. What is the best way to find this out ? I do not have auditing turned on. Where can I check ? It is Oracle 11g.
Thanks.