Temp Tablespace is full
Posted: Tue Jul 03, 2007 12:01 pm
hi All i have a very weird problem...the dafault temp tablespace of y database got 100% full so i added another datafile (of 5 GB) which became full in 2 days again...is this normal..well the data load on my database is really enourmous but according ti my understanding the contents of a temp are always re-writed so it shud rarely become full...
please suggest me a solution to this...
if i drop those datafiles and make some new will this have any impact on my database operation??
please reply!!
please suggest me a solution to this...
if i drop those datafiles and make some new will this have any impact on my database operation??
please reply!!