Is This Content Helpful?
How can we make this better? Please provide as much detail as possible.
Contact our Support Team
Can a multiversioned view be deleted without leaving an entry in the table registry?
Yes. To delete a multiversioned view, always use sdetable -o delete_mv_view.
Important facts about deleting multiversioned views:
· For -t, specify the name of the table or layer from which the view is created. For example: use the same value used in the -t option to create the multiversioned view. This procedure is shown below:
Code:
C:>sdetable -o create_mv_view -T shale_vw -t shale -i esri_sde -u sde -p sde
ArcSDE 9.1 Oracle10g Build 407 Mon Mar 5 10:50:46 PST 2007
Attribute Administration Utility
-----------------------------------------------------
Successfully created MV view shale_vw for table shale.
C:\>sdetable -o delete_mv_view -t shale -i esri_sde -u sde -p sde
ArcSDE 9.1 Oracle10g Build 407 Mon Mar 5 10:50:46 PST 2007
Attribute Administration Utility
-----------------------------------------------------
Delete MV view for table shale?
Are you sure? (Y/N): y
Successfully deleted MV view for table shale.
Code:
C:\>sdetable -o create_mv_view -T shale_vw -t shale -i esri_sde -u sde -p sde
ArcSDE 9.1 Oracle10g Build 407 Mon Mar 5 10:50:46 PST 2007
Attribute Administration Utility
-----------------------------------------------------
Successfully created MV view shale_vw for table shale.
Code:
C:\>sdetable -o create_mv_view -T beach_vw -t beach -i esri_sde -u sde -p sde
ArcSDE 9.1 Oracle10g Build 407 Mon Mar 5 10:50:46 PST 2007
Attribute Administration Utility
-----------------------------------------------------
Successfully created MV view beach_vw for table beach.
C:\>sdetable -o delete -t beach_vw -i esri_sde -u sde -p sde
ArcSDE 9.1 Oracle10g Build 407 Mon Mar 5 10:50:46 PST 2007
Attribute Administration Utility
-----------------------------------------------------
Delete table beach_vw! Are you sure? (Y/N): y
Successfully deleted table beach_vw.
C:\>sdetable -o create_mv_view -T beach_vw -t beach -i esri_sde -u sde -p sde
ArcSDE 9.1 Oracle10g Build 407 Mon Mar 5 10:50:46 PST 2007
Attribute Administration Utility
-----------------------------------------------------
Error: DBMS view exists (-238).
Error: Unable to create MV view beach_vw for table beach.
Code:
UPDATE table_registry
SET imv_view_name = NULL
WHERE table_name = 'BEACH' AND owner = '<owner of BEACH>'
Code:
UPDATE sde_table_registry
SET imv_view_name = NULL
WHERE table_name = 'BEACH' AND owner = '<owner of BEACH>'
Last Published: 5/5/2016
Article ID: 000009475