The temporary tables are created in the source database. I don't have a scenario to offer more specific than those described in the article - they're created when you open the workbook and contain information about things like filters and data blending.
Thanks for the details.
Oracle DB -> Tableau Desktop -> Tableau Server -> Tableau DB
Where this temp table gets created?
The temporary tables in this case would be created in the Oracle DB