We had an 11.0.2.4 instance with an oracle wallet created, but after some issues with the server the master key file got lost.
Because this was a development server there was no available backup but the data wasn't so important. We created a new wallet with a new master key that is now open and "working".
For some queries to work we used the alter table <table_name> rekey command, and tested the environment by doing a select * over all the tables with encrypted columns (we only have encrypted columns in some tables, not encrypted tablespaces) and it worked. But with certain more complicated queries (between several tables) we are getting ORA-28362.
Is it possible to recover from the lost of the previous wallet and could this error have to do with that? Would we need to recreate the tables?
Thanks for any ideas!