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