in reply to oracle temp table does not exist

Seems that it might be that the select statement needs the table to be fully qualified. Select * from HR.Tempest