Solved

Having an issue with temp datafile

Posted on 2007-04-09
2
987 Views
Last Modified: 2008-01-09
SQL> select * from dba_temp_files;
ERROR:
ORA-01157: cannot identify/lock data file 202 - see DBWR trace file
ORA-01110: data file 202: 'F:\ORACLE\ORADATA\IWDBT\TEMP01.DBF'

I just ran this query against my database. The path f:\oracle\oradata\iwdbt\ doesn't exist in my environment. How can I get this fixed? The correct path is f:\oracle\oradata\iwdb
0
Comment
Question by:ACSDBA
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 35

Accepted Solution

by:
johnsone earned 500 total points
ID: 18877797
These 2 steps should work:

alter database tempfile 'F:\ORACLE\ORADATA\IWDBT\TEMP01.DBF' drop;
alter tablespace <temp_ts> add tempfile 'F:\ORACLE\ORADATA\IWDBF\TEMP01.DBF' size <size>;

You need to substitiute in the tablespace_name for <temp_ts> and the size of the temp file for <size>.
0
 
LVL 7

Expert Comment

by:Fayyaz
ID: 18880554
Hope below steps will help

1). Create another temporary tablespace
2). Make this newly created tablespace as default temporary tablespace
3). drop the old temporary tablespace including temp files.

0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question