PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Steven Cruz <steve at nextopia dot com>
Subject: Re: only one record in table
Date: Aug 3 1999 2:00PM

Hello;

	It seems you ran out of database space. You have to add a new device to
the database server, then alter the databsae on the that device. 


	If you need more information please let me know. 

8-)
Steven Cruz
Oliver Scheit wrote:
> 
> Please excuse my bad knowledge about this.
> 
> I have a table where I can insert one record.
> If I try to insert a second record, I get:
> 
> Message String: Can't allocate space for object 'net_hw' in database
> 'db2' because the '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.
> 
> Server message:
> Message number: 7101, Severity 17, State 1, Line 1
> Message String: Unable to allocate new text value, dbid 5.
> 
> I don't really understand, what is wrong.
> Also, I don't really understand what I'm supposed to do.
> How can I find out whether I ran out of space in syslogs or not?
> How to dump the transaction log?
> 
> If anyone could find the time to give me a hint,
> I'd be grateful.
> 
> Regards,
> Oliver Scheit