can not add datafile to 'undobts1' tablepsace.
457251Nov 12 2005 — edited Nov 13 2005Hello friends,
I get the following error message while i try to add a datafle to the 'undotbs1' tablespace.
I have Oracle 9i in Win Xp. I have free diskspace of around 5 GB on drive 'F:'
----
SQL> ALTER TABLESPACE UNDOTBS1 ADD DATAFILE 'F:\ORADATA\UNDOTBS\UNDOTBS02.DBF' SIZE 500M;
ALTER TABLESPACE UNDOTBS1 ADD DATAFILE 'F:\ORADATA\UNDOTBS\UNDOTBS02.DBF' SIZE 500M
*
ERROR at line 1:
ORA-01119: error in creating database file 'F:\ORADATA\UNDOTBS\UNDOTBS02.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 32) The process cannot access the file because it is being used
by another process.
----
What could be the reason...?
Besides, is 'undotbs1' the same 'rbs' tablespace in Oracle 8i....?
With regards,
thomaskprakash