How to define all global temporary tables

Question

I need to determine which tables in my schema are global temporary tables . After the script returns the names of all my tables, but I can not determine which of them are GTT and which are not.

SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('TABLE') AND OWNER='owner_name'; 

Thanks!

Answer 1

You can use ALL_TABLES

 select table_name from all_tables where TEMPORARY = 'Y' AND OWNER='owner_name'; 

Column

Temporary indicates whether the table is temporary ( Y ) or not ( N )