Oracle Database Discussions

Oracle 11g - 11.1.0.7, Redhat 5.3 64BIT w/4GB RAM
================================

Hello All,

I just inherited a DB from a person that left the company, and I've noticed something interesting in the TEMP tablespace. One file is located in /u02 and the additional file that was added latter - is staged at /u01. To make matters worse, temp01.dbf is a 968MB file where 744MB is being used, (no auto extend), temp02 looks like it was mistakenly created at 25GB (should have been 2GB) and it is using 3GB of space (with Auto extend on).

I would like to first delete temp02 from the /u01 folder and recreate it in /u02 with its partner, but as a 2GB file only. What is the best way to proceed with this? Should I mount the DB, (not open) then drop and recreate it? Can it be done in an 'OPEN' state?

Thanks.

Ron


Current Configuration:

temp01.dbf /u02/oradata/CTS/ 968.36 744.00

temp02.dbf /u01/oradata/CTS/ 25,792.00 3,009.00