How to identify all global temporary tables
You can use ALL_TABLES
select table_namefrom all_tableswhere TEMPORARY = 'Y'AND OWNER='owner_name';
Temporary
column indicates whether the table is temporary (Y
) or not (N
)
You can use ALL_TABLES
select table_namefrom all_tableswhere TEMPORARY = 'Y'AND OWNER='owner_name';
Temporary
column indicates whether the table is temporary (Y
) or not (N
)