Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Recreating of TEMP file and TEMP Tablespace

1009070Jun 7 2013 — edited Jun 7 2013
Hi!
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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2013
Added on Jun 7 2013
5 comments
1,102 views