Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server Error 1105: Can't allocate space for object 1

Status
Not open for further replies.
Ruairi

Ruairi

Programmer
May 14, 2000
314
US
I am getting the error message
"Can't allocate space for object logs in database 'GPTEST' because 'default' segment is full. If you ran out of space in syslogs, dump the transaction log. Otherwise use Alter Database or sp_extendsegment to increase the size of the segment."
The log has 1 GB free and the database has 500 MB free. The table i am trying to build a clustered index on has roughly 4,000,000 rows. The data already is ordered by that field. I am using SQL Server 6.5. I would appreciate any insight into this problem. Obviously the server needs more temporary storage, but what do i need to resize? i have already tried using sp_extendsegment to extend the 'default' segment of the database, but only by 100 MB or so. I got the same error after extending the segment. Thanks in advance for any help. Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.
 
Sort by date Sort by votes
Recall that to build a clustered index, it requires, on the average, 1.2 times the size of the table you are building it on for 'working space'. It's apparent that you are attempting to build the index on that segment (the default), and that segment is outta space...

Are you trying to build the clustered index on a segment that is full (the default)? Do you have another segment that you could place it on?

So.. .could you describe the segments you have allocated to your database... I'm assuming you have more that 1...

Tom Davis
tdavis@sark.com
 
Upvote 0 Downvote
Tom,
Thanks for responding. I haven't specifically defined any segments in this DB. I guess that means all i have is one segment? To be honest this is one part of SQL server i don't know anything about. I think your answer did gove me the clue i needed though. The logs table is approx. 535 MB and there is only about 500 MB free for the database. Im going to try expanding that to 1 GB and see if it helps.
Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.
 
Upvote 0 Downvote
Tom, that did the trick. thanks for your help. Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MathiasB
  • Question
Parameterised sql server query
Replies
8
Views
450
Chriss Miller
C
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
790
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
985
pjw001
pjw001
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
590
Chris Miller
Chris Miller
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
668
Mike Lewis
Mike Lewis

Part and Inventory Search

Sponsor

Back
Top