Oracle Solution for Error ora-30927

ORA-30927: Unable to complete execution due to failure in temporary table transformation

What triggered the Error:

In memory temporary tables we create are aged out of shared pool before we are able to grab them again.

What should we do to fix it:

Reduce activities that use a lot of shared pool space or wait for a while, then retry.