Temporary tablespaces

From: Vikas Agnihotri <fornewsgroups_at_vikas.mailshell.com>
Date: 21 Aug 2001 13:40:22 -0700
Message-ID: <902027f8.0108211240.4b22fa42@posting.google.com>

This might be a very silly question, but what is the difference between

'create tablespace temp ... temporary'

and

create temporary tablespace temp ...'

The former uses datafiles, the latter uses tempfile. In either case, permanent objects cannot be stored. The latter stores objects only for the duration of a session.

I read all the relevant docs, but in terms of practical usage, whats the diff?

More importantly, where would you use one over the other?

Thanks Received on Tue Aug 21 2001 - 15:40:22 CDT