Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temporary tablespaces
you should always use temporary type tablespaces with tempfiles - 2
big wins:
- eliminate contention for the ST (space management) enqueue - thats
what having a tablespace of type temporary gets you
- don't have to be backed up - thats what tempfiles gets you as they
are not considered part of the recovery set.
fornewsgroups_at_vikas.mailshell.com (Vikas Agnihotri) wrote in message news:<902027f8.0108211240.4b22fa42_at_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 - 20:01:57 CDT