Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Cant alter table?
147 views
Skip to first unread message
David
May 17, 2001, 10:09:00 PM5/17/01
to
Hi,
When I tried to alter table use
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
May 19, 2001, 11:24:36 PM5/19/01
to
orac...@eastmail.com wrote...
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
0 new messages