Quick question on low disk space
I'm facing the low disk space issue at the database server, I’m seeking recommendation to overcome this issue.
The original hard disk for C:\ is only 19.5GB, and the oracle already taken ~10GB. The current disk space is only 1.22 GB which is critical low.
I have tried to purge the historical data, but it doesn’t help to clear off the disk space.
Concern:
1) Can we point the oracle to another hard disk said from C:\ to E:\ ?
2) What is the temp01.dbf for? Can we resize it? How can i check this temp01 is being used for which table? The temp01.dbf is taken _4GB disk space.
Thanks