Thursday, August 30, 2012

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>

No comments: