Deleting multiversioned views
To remove a multiversioned view from the database, use the sdetable command with the delete_mv_view operation.
![Attention Attention](rsrc/caution.png)
Do not use Structured Query Language (SQL) to drop your multiversioned view.
Etapes :
-
To delete a multiversioned view named parcels_mv that was created on a table named parcels, use the sdetable command with the delete_mv_view operation. Examples for each DBMS are shown here.
- IBM DB2
sdetable –o delete_mv_view –t parcels -i sde:db2 –D landbase –u bjorn –p a.secret
- IBM Informix
sdetable –o delete_mv_view –t parcels -i sde:informix –D landbase –u bjorn –p a.secret
- Oracle
sdetable –o delete_mv_view –t parcels -i sde:oracle11g –u bjorn@ora11sv –p a.secret
- PostgreSQL
sdetable –o delete_mv_view –t parcels -i sde:postgresql:server1 –D landbase –u bjorn –p a.secret
- Microsoft SQL Server
sdetable –o delete_mv_view –t parcels -i sde:sqlserver:myserver\sqlinstance –D landbase –u bjorn –p a.secret
For complete syntax information for the sdetable command, see the ArcSDE Administration Command Reference provided with the ArcSDE component of ArcGIS Server Enterprise.
Astuce :
If you are using ArcSDE for PostgreSQL and accidentally drop your multiversioned view at the SQL prompt rather than using sdetable –o delete_mv_view, use the sde_clean_rule_functions to unreference the rule functions.
SELECT sde_clean_rule_functions();
- IBM DB2
Rubriques connexes
7/10/2012