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

It's a tempfile. U have to use resize like this:

ALTER DATABASE TEMPFILE
'/u01/oracle/oradata/dev/imtemp_tablespace.dbf' RESIZE 1024M;

;-)

spraveen2001_at_yahoo.com (Praveen) wrote in message news:<98d8ec76.0303062209.2463a453_at_posting.google.com>...
> 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
Received on Mon Mar 10 2003 - 16:52:15 CET