Alter Database...Resize ... Error!!!!

From: Praveen <spraveen2001_at_yahoo.com>
Date: 6 Mar 2003 22:09:42 -0800
Message-ID: <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 Fri Mar 07 2003 - 07:09:42 CET