Re: AUTOEXTEND: tempfiles

From: SW <flyhorse_127_at_hotmail.com>
Date: 7 Dec 2004 20:05:38 -0800
Message-ID: <1102478738.644581.323620@f14g2000cwb.googlegroups.com>

wagen123_at_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. Received on Tue Dec 07 2004 - 22:05:38 CST