NIM056614 for ArcSDE/Enterprise Geodatabase

不具合 ID 番号	NIM056614
送信されました	April 22, 2010
最終更新日	April 2, 2025
適用対象	ArcSDE/Enterprise Geodatabase
見つかったバージョン	9.3.1
オペレーティングシステム	Oracle Solaris
オペレーティングシステムのバージョン	10
ステータス	Non-Reproducible

参考情報

No Public Explanation

対処法

One workaround would be to create a script that would be used to recreate the multiversioned views after doing the upgrade. Prior to upgrade, something like the following query would retrieve the mv view information and create a script:select 'sdetable -o create_mv_view -T '|| imv_view_name || ' -t '|| table_name ||' -i 5151 -u ' || owner || ' -p ' || owner || '_PASSWORD' from sde.table_registry where imv_view_name is not null;It appears that after the MV View is deleted during upgrade, there is still information left in the SDE.TABLE_REGISTRY.IMV_VIEW_NAME column. This prevents the MV View from being recreated afterwards, until IMV_VIEW_NAME is set to NULL.After recreating the views, appropriate permissions on the views would need to be granted, if necessary.