ORA-30927: Unable to complete execution due to failure in temporary table transformation
Cause: In memory temporary tables we create are aged out of shared pool before we are able to grab them again
Action: Reduce activities that use a lot of shared pool space or wait for a while, then retry
https://support.oracle.com/
http://www.oracle.com/