AUTOEXTEND: tempfiles

[wage...@yahoo.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

[wage...@yahoo.com]

[wage...@yahoo.com]

[Vicchu]

Try this syntax :

alter database tempfile '/oracle/admin/TEST/oradata/TESTTEMP02' autoextend on next 10m maxsize 50m;

Vishwa

[SW]

wage...@yahoo.com wrote:
>
> 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

Since the database files assocaited with a temporary TBS are temp
files, you can't use 'datafile' clause to change the file parameters.
Try 'tempfile' instead.

[Christopher Jung]

Autoextending temp sounds dangerous. Someone accidentally cartesian joins
some large tables together, temp tablepsace files filesystem, then finally
query errors out.

<wage...@yahoo.com> wrote in message
news:1102473437....@z14g2000cwz.googlegroups.com...