Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> difference between temporary tablespaces
Hi!
I'm getting kinda confused concerning the two types of temporary tablespaces:
create tablespace NAME temporary... is the "old" way of creating a temporary tablespace for sorting purposes. It only allows for sort segments to be stored there. And it can only be dictionary managed, right?
create temporary tablespace NAME tempfile... is the "new" way for it. It can either be dictionary managed or locally managed.
But the complete reference says that this tablespace will only be used for temporary tables. Does this tablespace also allow for sort segments?
Or do I need both types of tablespaces?
This is 8.1.7 on Sun Solaris.
Thanks,
Helmut
Received on Wed Dec 05 2001 - 03:16:55 CST
![]() |
![]() |