| Tablespace FULL message [message #243704] |
Fri, 08 June 2007 09:17  |
preet_kumar
Messages: 204
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
