What is the difference between a temporary tablespace and a parmanent tablespace?
Sapna Malik
The temporary tablespace show always from temp name in the database. The temporary tablespace is store in tempfile. All temporary operation are perform in temporary tables. The temporary tablespace is used for the shorting temporary tables.
The user and normal tablespace is a permanent tablespace. All user tablespace information store/show in the user tablespace.