Get list of temperory tables from database

I want to find out the names of temperory tables from oracle database?

Junior Poster

126 posts since Nov 2008

Reputation Points: 10

Solved Threads: 2

select *
from all_tables
where temporary='Y'

Newbie Poster

10 posts since Sep 2009

Reputation Points: 10

Solved Threads: 5

This question has already been solved

You