ORA-30927

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

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

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