Re: File exists error message with REUSE option

  • From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
  • To: dba.orcl@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 04 Sep 2005 11:46:25 +0800


If you specify SIZE 50M,  the existing file MUST be 50M in size.

Hemant
At 10:15 AM Sunday, Sami Seerangan wrote:

All,

Why am I getting "File exists" error message when I specified  REUSE option.

Oracle 9.2.0.6, 2 Node RAC
Veritas Cluster file system
Solaris 9


SQL> alter tablespace temp add tempfile
'/u04/oradata/dgtest/temp01.dbf' size 50M REUSE;
alter tablespace temp add tempfile '/u04/oradata/dgtest/temp01.dbf'
size 50M REUSE
*
ERROR at line 1:
ORA-01119: error in creating database file '/u04/oradata/dgtest/temp01.dbf'
ORA-17502: ksfdcre:4 Failed to create file /u04/oradata/dgtest/temp01.dbf
ORA-17500: ODM err:ODM ERROR V-41-4-17 File exists


If I remove the file using OS command then it works fine.

Thanks
Sami
--
//www.freelists.org/webpage/oracle-l



Hemant K Chitale
http://web.singnet.com.sg/~hkchital


--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2005