Unable to fix remove multi-versioned views

[ShanaLowe]

I had a bunch of multiversioned views that no longer work (they exist but the data does not display).  I thought I could just drop them and recreate them, but am having issues with this.  When I drop from ArcCatalog (I read that this is the proper way to drop the view), I don;t get an error message, but it does not drop.  I tried dropping using "sdetable -o delete_mv_view -t <view name> -i 5151 -u <user> -p <passord>, but I get an error message that the "Table is unregistered" and thefore it is unable to drop the view.  I then dropped using SQLPlus, which, it appeared to drop it, but when I re-create it, I get a message that it already exists.

Any help would be greatly appreciated-

[KimPeter]

Hi Shana,

I'm curious to know where you read that multiversioned views should be dropped via ArcCatalog...Or were you referring to the table on which the view was based?

Also, the syntax you mention

sdetable -o delete_mv_view -t <view name> -i 5151 -u <user> -p <passord>

should be

sdetable -o delete_mv_view -t <table>...
http://help.arcgis.com/en/geodatabase/10.0/admin_cmds/Support_files/admincmdref.htm

The record for the multiversioned view still exists in the ArcSDE system table, so you won't be able to create another multiversioned view with that name on that table until you have successfully run sdetable -o delete_mv_view to drop the existing view.

If you find this is not working, please contact support.

-Kim

[ShanaLowe]

Thank you.  I did have the syntax wrong on the delete.  I was able to delete the views and re-create them, but am having the same issue that I oroiginally had with the views.  I create them using the following:
sdetable -o create_mv_view -T mv_mains -t w_mains -u pwd -p network

It creates successfully, but then when I try to view in ArcCatalog, nothing displays.  If I try to open in ArcMap, I get an error message that "Abstract Data Types not supported". 

Thanks again!