unable to delete a table

[Joel W Winston]

Dear All,

I have a 9.1D db and I am not able to delete a particular table in the DB.

When I try to delete the table I get a message saying "** Field <field-name> is a component of an Index. (185)"

But I have deleted the indexes which use that specific field.

What could be the reason?

Please advise.

Thanks
Joel

 

[Cringer]

Have you made sure the transaction as committed from when you deleted the indexes?

 

[Joel W Winston]

Have you made sure the transaction as committed from when you deleted the indexes?

Yes I committed the deletions of the indexes.

 

[cj_brandt]

Is there a trigger on the table giving you grief ?

Does the db engine support the SQL drop table command in 9.1D ?
proserve db-name -S 1234
sqlexp -db db-name -S 1234 -user xxx -password xxx
drop table;
commit;

 

[Joel W Winston]

Is there a trigger on the table giving you grief ?

Does the db engine support the SQL drop table command in 9.1D ?
proserve db-name -S 1234
sqlexp -db db-name -S 1234 -user xxx -password xxx
drop table;
commit;

Thanks for the reply.
There are no triggers defined.
I will try the "SQL Drop table" and let you know.
Thanks
Joel

 

[Joel W Winston]

"SQL Drop table" does not work.

We are going to do a Dump and Reload. No other option left.

Thanks anyways.

 

[cj_brandt]

You could have tried to rename the table via the schema editor and then created the table again. Of course you still are stuck with that old table, but avoids a reload.

 

[Joel W Winston]

Thats a good suggestion.

Thanks
Joel

 

[Joel W Winston]

And may be freeze the renamed old table as well. Any idea if the CRC gets affected for the programs that use that specific table? Would it need a recompile?

Thanks
Joel