Hello:

I have a Temp TS and I have 4 datafiles in it and when a user runs a query it is erroring out with ora-01114. Complaining on certain block and file. Now to drill down to the right place, I want to make one datafile unavailable at a time, run the query. Is this a valid option? If so, how do I go about doing it?

Thanks, ST2000