difference between temporary tablespaces

From: Daiminger, Helmut <Helmut.Daiminger_at_KirchGruppe.de>
Date: Wed, 05 Dec 2001 01:16:55 -0800
Message-ID: <F001.003D585F.20011205005518@fatcity.com>

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