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.

Cant alter table?

2 posts in Windows NT Last posting was on 2001-05-20 03:24:36.0Z
David Posted on 2001-05-18 02:09:00.0Z
Reply-To: "David" <oracledba@eastmail.com>
From: "David" <oracledba@eastmail.com>
Subject: Cant alter table?
Date: Fri, 18 May 2001 12:09:00 +1000
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <ryhIvJ03AHA.164@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 203.76.4.111
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:717
Article PK: 1087324

Hi,
When I tried to alter table use

alter table test add tel varchar(30) null,phone null
go

It return error:
cannot alter table if REORG command or level 0 scans are active.

What does it mean and how to fix it? My db is ASE12 on NT4.


Thanks


Jim Egan Posted on 2001-05-20 03:24:36.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: Cant alter table?
Date: Sat, 19 May 2001 21:24:36 -0600
Message-ID: <MPG.1570e6e4e7febc8198b382@forums.sybase.com>
References: <ryhIvJ03AHA.164@forums.sybase.com>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.50
Newsgroups: sybase.public.sqlserver.nt
Lines: 15
NNTP-Posting-Host: c1420400-b.hiland1.co.home.com 65.7.153.228
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:711
Article PK: 1087318


oracledba@eastmail.com wrote...
> Hi,
> When I tried to alter table use
>
> alter table test add tel varchar(30) null,phone null
> go
>
> It return error:
> cannot alter table if REORG command or level 0 scans are active.
>
> What does it mean and how to fix it? My db is ASE12 on NT4.

It may be that other users are on the system running queries. Just for grins, try running
two commands. One to add each column.
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Get your free subscription to PowerTimes at http://www.powertimes.com