Hello Guys,
I am getting the following error on Sybase Adaptive Server 15
Error 1581
"Create index was aborted because pages in the data only locked table
are not linked"
By the way... - the table is an ALL PAGES SCHEME!
I firstly create a table
-------------------------------
create table temp_liz
(
log_id int
)
Then I select into this table from other tables in a join clause. (in
the real script)
but this also causes the error...
----------------------------------------------
select log_id
into temp_liz
from temp_LL - just dummy names of course:)
Then I create a clustered index on the leading column which includes
the "with sorted_data" option and others, like "with consumers = 4"
--------------------------------------------------------------
create clustered index idx_liz
on temp_liz (log_id)
with sorted_data, consumers = 4
Even though this is NOT a "DOL" (data only locked) table, I still get
the issue
NB: sp_help re****ts ALL PAGES locked scheme. (Lock scheme Allpages)
Our Sybase server version is:
Enterprise 15.0.2 EBF 15093 ESD#2PSun_svr4OS 5.8ase1502251664-bit
FBOThu Dec 20 040537 2007
On another Sybase installation, I only get this error:
--------------------------------------------------------------------------
Adaptive Server Enterprise/12.5.3/EBF 13325 ESD#7/P/Sun_svr4/OS 5.8/
ase1253/1951/64-bit/FBO/Fri Mar 24 11:00:22 2006
Create index with sorted_data was aborted because of row out of
order.
Primary key of first out of order row is '1018'
Msg: 1530, Level: 16, State: 2
I am aware of the issue surrounding the with SORTED_DATA on a DOL
table, but like I said this is an ALL PAGES Locked scheme and the data
was not bcp'ed into the table.
Any ideas, will help a lot!
Liz
|
