Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temp Tablespace
Thanks !!
That really helped !
Regards,
Sunil.
"Kenneth Koenraadt" <plovmand_at_mail-online.dk> wrote in message
news:25fb645f.0210230017.101075a8_at_posting.google.com...
> Sure,
>
> You can create a temporary tablespace in 2 ways :
>
> a) create tablespace temp datafile 'filea.dfb' size 100m temporary;
>
> b) 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 Fri Oct 25 2002 - 03:35:30 CDT