My on-site DBA told me to create the particular table on temporary tablespace.Is there any advantage of such action?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
I believe your DBA told you to use temporary tablespace for temporary data? If so using temporary tables have the following advantages:
Of course I forgot something. :) People will add more advantages in comments.
While listing advantages I am not considering scenario when you have to preserve data between restarts.