I have an error "ORA-01537" when I create a tablespace.
create tablespace "VOLUMT" datafile 'VOLUMT.dbf' size 250M autoextend on;
Then, it shows like following.
ERROR at line 1: ORA-01537: cannot add file 'VOLUMT.dbf' - file already part of database
I just change the tablespace name of VOLUMT to TEST01, and it works..
Tablespace created.
So, I get into the directory of db and searched the related tablespace..
${HOME}/oracle/db/oradata/ORAC12
However, I can't find any.. Coudl you help me to solve this problem? Also I need to use "VOLUMT" for tablespace creation.. not TEST01..
-- Additional --
select TABLESPACE_NAME from DBA_DATA_FILES; TABLESPACE ---------- SYSTEM SYSAUX USERS TEST01
I can see TEST01 Tablespace, but I can't find any datafiles in the directory. Also I can't find any VOLLMT tablespace in it..
Thank you.
select TABLESPACE_NAME, file_name from DBA_DATA_FILES;
? – a_horse_with_no_name May 17 '18 at 6:01