Page 1 of 1

Temp Tablespace is full

Posted: Tue Jul 03, 2007 12:01 pm
by Majid_noor
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!!

Posted: Mon Jul 16, 2007 2:27 am
by iftikhar
My Dear,
Your All database tables must have Primery key constraints and should be in their own tablespace and all the scheema should their own index and temporary tablespace.
Now implement this and let me know.