Re: Versioning Problem

noplan wrote:
> We are using workspace manager to provide audit logs for some of our
> tables. Thus, we enabled versioning for these tables using the
> VIEW_WO_OVERWRITE option. Everything works fine using the version
> enabled tables. Then one of our employees tried to drop the version
> enabled tables and the corresponding views workspace manager had
> created during version enabling. He did not version disable the tables
> first but manually tried to drop all tables/views. Now we are stuck
> with some remaining tables/views which cannot be dropped. However,
> workspace manager still thinks these tables are version enabled and
> complains when we try to merge a workspace with the LIVE workspace,
> stating that some (WM generated) view for the corrupted version
> enabled tables has errors. We also cannot drop the whole schema
> because it has version enabled tables in it, according to WM.
> Any ideas are greatly appreciated.

Well, hopefully someone else may have a more helpful reply, but the only way I've ever found to resolve this sort of chaos is to remove the entire workspace and start from scratch.

Regards
HJR Received on Wed Apr 14 2004 - 03:57:11 CDT