Autoextending temp sounds dangerous. Someone accidentally cartesian joins
some large tables together, temp tablepsace files filesystem, then finally
query errors out.
<wagen123_at_yahoo.com> wrote in message
news:1102473437.558774.35000_at_z14g2000cwz.googlegroups.com...
> Created a temporary tablespace (tempfiles) WITHOUT the AUTOEXTEND
> CLAUSE.
>
> How can add the AUTOEXTEND CLAUSE to an existing temporary tablespace
> with tempfiles?
>
> I don't want to create another temp tablespace and drop the existing
> tbs....
>
> The error is not reported for regular datafiles.
>
> SQL> alter database datafile '/oracle/admin/TEST/oradata/TESTTEMP02'
> autoextend on next 10m maxsize 50m;
> alter database datafile '/oracle/admin/TEST/oradata/TESTTEMP02'
> autoextend on next 10m maxsize 50m
> *
> ERROR at line 1:
> ORA-01516: nonexistent log file, datafile, or tempfile
> "/oracle/admin/TEST/oradata/TESTTEMP02"
>
> Thanks much.
> wagen
>
Received on Wed Dec 08 2004 - 07:25:30 CST
