dear sir ,

In oracle 9i we can have multiple temporary tablespace and one default temporary tablespace for database.

Say I have 5 temporary tablespaces I can switch between them to make any one of them default for that database.

I just want to know from which of data dictionary view I can get information about current temporary tablespaces.


bye
virajvk