Here i have explain what we can do when our database runs out of space.
1.) How Oracle managed sorting operations
2.) How DBA determines and handle the database when temporary tablespace running out of space
Click Here for next Part II :
For more detail about temporary tablespace Click Here