Re: Cannot add Index...error 106

Posted in 1999

Mark D. Stock — Fri, 21 May 1999 10:48:07 +0200 — source: Informix-list mailing list archive (1991-1998)

s00877 wrote: > > I am trying to add an index, but I get an error message saying the db muse > be opened in EXCLUSIVE mode. > My question is how\\where do I do this or is there a way to take the db > off-line add the indexes and give it back to the system. It's not the database it needs exclusive access to, it's the table. Make sure there is no one using that table before you run the command. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |What year 2000 bug? year 2000 bug? |/// / ////| | Fax: +27 838250 2325 |year 2000 bug? year 2000 bug? year |// / /////| |Cell: +27 83 250 2325 |2000 bug? year 2000 bug? year 2000 |/ ////////| +----------------------+-----------------------------------+-----------+