Temp Tablespace is full

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
Majid_noor
Posts: 9
Joined: Sun Jun 03, 2007 7:08 am
Location: Saudi Arabia

Temp Tablespace is full

Post 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!!
iftikhar
Posts: 6
Joined: Wed Apr 04, 2007 8:51 am
Location: Pakistan

Post 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.
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests