Re: Alter Database...Resize ... Error!!!!

Praveen wrote:
> Hi All,
>
> I am trying resize the tablespace data file.But it is saying, file not
> found eventhough the data file exists. What might be the problem? The
> following are commands which i ran to do that.
>
> select name,status from v$datafile;
>
> /u01/oracle/oradata/imusers_small01.dbf
> ONLINE
>
> /u01/oracle/oradata/imusers_medium01.dbf
> ONLINE
>
> NAME
> --------------------------------------------------------------------------------
> STATUS
> -------
> /u01/oracle/oradata/dev/imusers_large01.dbf
> ONLINE
>
> /u01/oracle/oradata/dev/imusers_small_ix01.dbf
> ONLINE
>
> /u01/oracle/oradata/dev/imusers_medium_ix01.dbf
> ONLINE
>
> NAME
> --------------------------------------------------------------------------------
> STATUS
> -------
> /u01/oracle/oradata/dev/imusers_large_ix01.dbf
> ONLINE
>
> ALTER DATABASE DATAFILE
> '/u01/oracle/oradata/dev/imtemp_tablespace.dbf' RESIZE 1024M;
> ALTER DATABASE DATAFILE
> '/u01/oracle/oradata/dev/imtemp_tablespace.dbf' RESIZE 1024M
> *
> ERROR at line 1:
> ORA-03296: cannot resize datafile - file
> /u01/oracle/oradata/dev/imtemp_tablespace.dbf not found
>
> Thanks,
> Praveen

You might be trying to resize a temporary tablespace's tempfile. In that case you need to use the TEMPFILE clause instead of the DATAFILE.

Alex Ivascu Received on Thu Mar 13 2003 - 02:18:30 CET