ORA-01543: tablespace 'TEMP' already exists
877396Jul 22 2011 — edited Jul 22 2011Why do I receive that error? Take a look:
SQL> create temporary tablespace TEMP tempfile '/u07/oradata/DESQA/temp01.dbf' size 100m autoextend off;
ORA-01543: tablespace 'TEMP' already exists
SQL> select tablespace_name, file_name from dba_temp_files;
TEMP02 /u07/oradata/DESQA/temp02.dbf
TEMP01 /u07/oradata/DESQA/temp03.dbf
SQL> select tablespace_name from dba_data_files;
TABLESPACE_NAME
------------------------------
SYSTEM
PPM_INT
UNDOTBS1
SYSAUX
USERS
KNTA_DATA
CLOB
Else, no user has TEMP as temporary tablespace, it doesn´t exist!
Thanks for your help!