ORA-01537

This was tested on Oracle 11.2. You get the message above if you try to add a file to an instance more than once:

 

SQL> l

  1* select file_name from dba_temp_files

SQL> /

 

FILE_NAME

---------------------------------------------

/database/Andrew/ANDREW01/temp01.dbf

 

SQL> alter tablespace temp add tempfile

  2  '/database/Andrew/ANDREW01/temp01.dbf'

  3  reuse

  4  /

alter tablespace temp add tempfile

*

ERROR at line 1:

ORA-01537: cannot add file '/database/Andrew/ANDREW01/temp01.dbf' - file

already part of database

 

SQL>