On a running instance, I'm creating indexes (many at a time, by
using a DBMCLI script file). Some of the index cannot create, and the table
on which index is to be created is unusable.

The error I get is: -3007,Invalid sequence of DML and DDL statements, for
each SELECT request

I create a simple index:

CREATE INDEX DBM350_AL_IDX8 ON DBM350_AL (State) //(state is an integer
column)


this does not happened on that specific index, it happens when I create lot
of index like the previous one. No error is return on the index creation but
when requesting the table by SELECT count(*) FROM DBM350_AL

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to