Home » RDBMS Server » Enterprise Manager » Tablespace FULL message
Tablespace FULL message [message #243704] Fri, 08 June 2007 09:17 Go to next message
preet_kumar
Messages: 195
Registered: March 2007
Senior Member
Hello All,

There is a tablespace names sales consisting of 10 files(sales1,sales2....sales10)
Autoextend is enabled(512 KB) and Maximum File size is 2GB.
If i check the individual files they vary in size but all are less than 1GB which is less that 50% but still i get the message that my tablespace is full.
If i dont use autoextend and allocate initially 2GB for each files then i dont get this message but i dont want to waste the space which is not being used so i prefer autoextend.
Also i checked the threshold defined which is
Warning (%) 85
Critical (%) 97
Storage Settings
Extent Allocation:Allocation type automatic
Segment Space Management:Automatic

Is there any way to resolve this...
Thanks
Re: Tablespace FULL message [message #243705 is a reply to message #243704] Fri, 08 June 2007 09:37 Go to previous messageGo to next message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
Please follow the posting guidelines as stated in the STICKY post at the top of this forum.
http://www.orafaq.com/forum/t/83065/74940/
Re: Tablespace FULL message [message #243712 is a reply to message #243705] Fri, 08 June 2007 10:36 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Coalsece tablespace and then try.
Re: Tablespace FULL message [message #243780 is a reply to message #243704] Sat, 09 June 2007 00:14 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Add another datafile or colesec ..
Previous Topic: Changing the IP address of Grid Server
Next Topic: Oracle 10g admin pages non-functional
Goto Forum:
  


Current Time: Mon Dec 05 15:18:34 CST 2016

Total time taken to generate the page: 0.24047 seconds