| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: DBA_TABLESPACES ( CONTENTS = TEMPORARY / PERMANENT )
If a tablespace's contents are set to temporary then the only thing the tablespace can be used for is by the RDBMS engine for large-sorting queries in which the sorting & results cannot be kept entirely in memory before displaying. If the contents are set to PERMANENT then both temporary query results& sorting work and actual tables (ie create table ....) regardless of whether they are created temporarily or not can be stored in the tablespace. If you want to use your TEMP tablespace as both a place for the rdbms to do sorting and have stored procedures and SQL scripts create temporary tables for use during the procedure/script then set contents of TEMP to PERMANENT and have the user's TEMPORARY tablespace set to TEMP and make sure to specify the TEMP tablespace when creating YOUR temporary tables.
HTH
manoj67_at_hotmail.com wrote in article <6fpijt$ieh$1_at_nnrp1.dejanews.com>...
> I have a question on the difference between the
> tablespaces that are used for TEMPORARY contents,
> and those that for PERMANENT. Which tablespaces
> should be set to TEMPORARY and which ones to
> PERMANENT to take advantage of this feature.
>
> Please post the answers on the forum.
>
> Thanks,
> Manoj
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Thu Apr 02 1998 - 00:00:00 CST
 |
 |