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.
Received on Wed Apr 14 2004 - 03:43:40 CDT
