Re: temp tablespace questions....

cmercer_at_vibrant-1.com (Carl Mercer) wrote:

>I have a 9.0.1.2.0 instance that has a temporary tablespace (duh...).
>The tablespace was created as follows:
>
>CREATE TEMPORARY TABLESPACE "TEMP" TEMPFILE
>'/dev_tools/oracle/product/oradata/PRODDB/sys3/temp01.dbf'
>SIZE 50M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
>EXTENT MANAGEMENT LOCAL;
I would not recommend using auto and unlimited extents on temp. This is just an invite to some silly developer or user to pull one of them infinite running disk crashing queries-from-hell on the database, doing cartesians joins and using perverted S&M SQL (like doing the TO_CHAR on the date colum in the WHERE clause and not using the TO_DATE on the literal instead).

Don't you also at times wish that there is an optional WITH ASSASINATE parameter for the DROP USER statement? :-)

--
Billy