Re: Help: Cant drop table ! Why ? What to do ?
Hello Paul,
Thanks for your answer.
No the table was not locked. I found that the ???.idx file was
corruppted.
I Do the job with the follwing now:
1. create an identical table with another name via dbschema.
2. copy it over the old idx and dat file
3. do an update statistics
It works but i think it is a litte bit dirty
Do you now another way ?
Ciao Toto
Paul Watson wrote:
>
> Sounds like a locking error, somebody else is using the table
>
> Thorsten Geelhaar wrote:
> >
> > Hello ,
> >
> > I got an informix 5.43 and want to drop a table. But i got the
> > error 242. I have been root and has DBA priviliges. Can you say what
> > is wrong.
> >
> > Another question concerning it is : Can i drop a table manualy out of
> > of the systemtables, when i delete all insert concerning this table ?
> >
> > THANXS for All Helping Hands and Thoughts
> >
> > Toto
> >
>
> --
> Paul Watson #
> WF Software # If it was easy
> Tel ++44 1436 674729 # Everybody could do it
> Fax ++44 1436 678693 #
> www.wfsoftware.com/informix #
------------------------------------------------------
Thorsten Geelhaar Telefon: +49 231 5599 106
Dr. Materna GmbH Fax : +49 231 5599 100
Vosskuhle 37 e-mail : Thorsten.Geelhaar@materna.de
D-44141 Dortmund GERMANY
------------------------------------------------------