Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

bcp copy failed

6 posts in Windows NT Last posting was on 2001-01-26 12:23:37.0Z
Wilson Posted on 2001-01-14 16:52:16.0Z
From: wilson
Date: Sun, 14 Jan 2001 11:52:16 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: bcp copy failed
Message-ID: <6B22ABD9CC02C473005CAD3A852569D4.005CAD50852569D4@webforums>
Lines: 25
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1319
Article PK: 1088787

hi everyone,

I have a problem in bcp dump files. The error message is:
"Server Message: - Msg 1105, Level 17, State 1:
Can't allocate space for object 'ARD06' in database 'MEMBER' because
'default' segment is full/have no free extents. If you ran out of space in
syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or
sp_extendsegment to increase size of the segment."


I want to copy in the file to the database. The file size is 44.3MB. I know
this table used bcp command copy out of total rows have 457590 rows. But I
used bcp copy in process to 457000 rows send to SQL Server after display
the above error message. I don?t know I have any problems. The database
transaction log just used 10%. Please help me and get me opinion how to
fixed it.

Thank you.


Sybase Version: Adaptive Server Enterprise Plug-in/11.9.2.9/P/PC
Intel/Win32/9/OPT /
O/S: Windows 2000 Advanced Server
Database size: 50MB
Transaction log size: 100MB
Allow select into/bulk copy: enable


Lazar Posted on 2001-01-15 12:18:55.0Z
From: Lazar
Date: Mon, 15 Jan 2001 07:18:55 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: bcp copy failed
Message-ID: <52445E593AB61DD10043A671852569D5.005D4187852569D4@webforums>
References: <6B22ABD9CC02C473005CAD3A852569D4.005CAD50852569D4@webforums>
Lines: 3
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1317
Article PK: 1088783

You execute :
> bcp [you database]..ARD06 in [text file] -[parametres]
?


Wilson Posted on 2001-01-16 03:03:02.0Z
From: wilson
Date: Mon, 15 Jan 2001 22:03:02 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: bcp copy failed
Message-ID: <F7EC4D5DAF7990240010C1EC852569D6.00454403852569D5@webforums>
References: <6B22ABD9CC02C473005CAD3A852569D4.005CAD50852569D4@webforums> <52445E593AB61DD10043A671852569D5.005D4187852569D4@webforums>
Lines: 8
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1314
Article PK: 1088784

copy file in to database:
bcp MEMBER.dbo.ARD06 in [store the file path] -n -S [my server name] -U sa
-P -J big5

copy file out to database
bcp MEMBER.dbo.ARD06 out [store the file path] -n -S [my server name] -U sa
-P -J big5


Lazar Posted on 2001-01-16 10:24:10.0Z
From: Lazar
Date: Tue, 16 Jan 2001 05:24:10 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: bcp copy failed
Message-ID: <5FC6630EEEE9F3B5003924DC852569D6.0010E590852569D6@webforums>
References: <6B22ABD9CC02C473005CAD3A852569D4.005CAD50852569D4@webforums> <52445E593AB61DD10043A671852569D5.005D4187852569D4@webforums> <F7EC4D5DAF7990240010C1EC852569D6.00454403852569D5@webforums>
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1312
Article PK: 1088779

Try with parameter -b[number of line]


Juhiz Posted on 2001-01-26 12:23:37.0Z
From: Juhiz
Date: Fri, 26 Jan 2001 07:23:37 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: bcp copy failed
Message-ID: <832A5DF5F493912B00441493852569E0.002CFFEB852569D9@webforums>
References: <6B22ABD9CC02C473005CAD3A852569D4.005CAD50852569D4@webforums> <52445E593AB61DD10043A671852569D5.005D4187852569D4@webforums> <F7EC4D5DAF7990240010C1EC852569D6.00454403852569D5@webforums> <5FC6630EEEE9F3B5003924DC852569D6.0010E590852569D6@webforums>
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1282
Article PK: 1088748

Check your server logfile size. Too big?


George Saylor Posted on 2001-01-14 17:23:00.0Z
From: "George Saylor" <GMSAYLORIII@email.msn.com>
References: <6B22ABD9CC02C473005CAD3A852569D4.005CAD50852569D4@webforums>
Subject: Re: bcp copy failed
Date: Sun, 14 Jan 2001 12:23:00 -0500
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <h6G$vDlfAHA.216@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 1Cust154.tnt3.baltimore.md.da.uu.net 63.16.12.154
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1318
Article PK: 1088785

run sp_helpsegment 'default'

what is available?

<wilson> wrote in message
news:6B22ABD9CC02C473005CAD3A852569D4.005CAD50852569D4@webforums...
> hi everyone,
>
> I have a problem in bcp dump files. The error message is:
> "Server Message: - Msg 1105, Level 17, State 1:
> Can't allocate space for object 'ARD06' in database 'MEMBER' because
> 'default' segment is full/have no free extents. If you ran out of space in
> syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or
> sp_extendsegment to increase size of the segment."
>
>
> I want to copy in the file to the database. The file size is 44.3MB. I
know
> this table used bcp command copy out of total rows have 457590 rows. But I
> used bcp copy in process to 457000 rows send to SQL Server after display
> the above error message. I don?t know I have any problems. The database
> transaction log just used 10%. Please help me and get me opinion how to
> fixed it.
>
> Thank you.
>
>
> Sybase Version: Adaptive Server Enterprise Plug-in/11.9.2.9/P/PC
> Intel/Win32/9/OPT /
> O/S: Windows 2000 Advanced Server
> Database size: 50MB
> Transaction log size: 100MB
> Allow select into/bulk copy: enable