I don't believe so. Tableau needs these in order to prepare for the execution of the command.
I have a sample Oracle database where the login credentials does not have the right to execute the create and truncate commands but the data extracts are successfully executed. Which leads me to believe that Tableau does not need these commands to create extracts. If this is the case, where in Tableau can I turn off these commands?
If needed, the creation of temp tables can be managed by restricting permissions in the database. However, restricting the creation of temp tables may have an in impact on the overall performance of the workbooks and views.
It appears you can actually control the creation of these temp tables through TDC files - Customize Oracle Connections for Better Performance | Tableau Software