Recreating of TEMP file and TEMP Tablespace
1009070Jun 7 2013 — edited Jun 7 2013Hi!
I have a problem with recreating of TEMP file and TEMP Tablespace after I made a copy of my database.
I made a new TEMP file and TEMP Tablespace and set them as default:
SQL> CREATE TEMPORARY TABLESPACE TEMP3 TEMPFILE 'C:\app\Orcldata\orclcopy\TEMP05.DBF' SIZE 2000M;
SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP3;
But when a made a select to see them:
SQL> SELECT tablespace_name, file_name, bytes FROM dba_temp_files WHERE tablespace_name = 'TEMP3';
SELECT tablespace_name, file_name, bytes FROM dba_temp_files WHERE tablespace_name = 'TEMP3'
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 202 - see DBWR trace file
ORA-01110: data file 202: 'C:\APP\ORCLDATA\ORCL\TEST_IASTEMP.DBF'
I can't understand where is the problem.
Thx!