Oracle Solution for Error ora-39782
ORA-39782: Direct path prepare is not allowed after another context loading the same table has ended
What triggered the Error:
Direct path prepare called after a context loading the same table has ended.
What should we do to fix it:
Close all contexts before trying to create another that loads the same table as a previous context in the same session.