I frequently live the same problem on several tables, when I get this error
I stop then start "NOT RESTART" the firebird service then everything goes
OK.

My DB is working if its realy corupted I have a REAL problem big problem...

regards
burak

----- Original Message -----
From: "csswa" <csswa@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, May 01, 2002 7:17 PM
Subject: [ib-support] Re: object index is in use


> Can't do it, Duilio...
>
> >From langref manual:
>
> "Description DROP INDEX removes a user-defined index from a database.
> An index can be dropped by its creator, the SYSDBA user, or any user
> with operating system root privileges.
>
> IMPORTANT You cannot drop system-defined indexes, such as those for
> UNIQUE, PRIMARY KEY, and FOREIGN KEY.
>
> An index in use is not dropped until it is no longer in use."
>
> :-(
>
> Regards,
> Andrew Ferguson
> -- Like fuzzy logic, but without the logic.
>
>
>
> --- In ib-support@y..., Duilio Foschi <dedalus@y...> wrote:
> > I want to drop the primary index of a table, whose name is
> integ_366.
> >
> > When I write
> >
> > alter table Tablename drop constraint integ_366
> >
> > I get the error message
> >
> > "index is in use".
> >
> > Surely I am the only user of the database.
> >
> > I even rebooted, but the problem stays there.
> >
> > I need to drop the @#$% index.
> >
> > Any help ?
> >
> > TIA
> >
> > Duilio Foschi
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>