Re: Temp Tablespace

Sure,

You can create a temporary tablespace in 2 ways :

1. create tablespace temp datafile 'filea.dfb' size 100m temporary;
2. create temporary tablespace temp tempfile 'fileb.dbf' size 100m;

filea.dbf above appears in dba_data_files. It is an "ordinary" datafile, so to speak.

fileb.dbf above appears in dba_temp_files. It is a tempfile, cannot be recovered and needs not to be backed up. You just drop and recreate it.

b) is available from 8i and has more than the mentioned advantage over a) and should be preferred. Howard Rogers wrote a fine post on this. Go to http://groups.google.com and search on "temp tablespace vs. tablespace ... temp" to find it.

• Kenneth Koenraadt

"Sunil" <sunil_franklin_at_hotmail.com> wrote in message news:<Klgt9.4$to3.115_at_news.oracle.com>...
> Kenneth,
> Thanks for the thorough explanation.
>
> can you please give some more information on the "depending how you
> defined your temporary tablespace(s)." part?
>
> Thanks,
> Sunil.
>
Received on Wed Oct 23 2002 - 03:17:50 CDT