Unable to perform delete (error 12097)

Posted in 2007

JOHN FLORY — Tue, 11 Dec 2007 02:27:16 — source: IIUG Forums & Mailing Lists

sql that results in this error. DELETE FROM tc_cad_preload WHERE oid="a0dec1974db1f34c0114ba2129870000"; Results in: -12097 12097 Smart Large Objects: open: Bad smart-large-object address. Object might have been deleted. Object might have been deleted. I am running IDS 9.4 and the 'programmer' killed the process part way through a load and now when he tries to delete the table he gets a 12097. I will try to drop the table latter when the system is no in use. Is there another way to remove it and reclaim any space in the sbspace?

Related threads

Enterprise Replication problem
Smart Blob errors