menghaupus user sde akan merusak data GIS secara permanen karena hilangnya register data "SDE.ST_GEOMETRY dan SDE.ST_RASTER COLUMNS"
untuk memperbaiki data di atas dengan menghapus database dan restore kembali ke waktu sebelum sde user di hapus
It is unwise to drop users before their tables have been gracefully removed from the geodatabase metadata catalogs. Best practice is to remove geodatabase-registered feature classes using ArcObjects/Python, and to remove SDE-registered tables/views using ArcObjects/Python or 'sdetable -o delete'. If you have corrupted your metadata, it is unlikely you will be able to upgrade the geodatabase before obtaining assistance from Tech Support.
The only time DROP USER ... CASCADE is really appropriate is when you're planning to drop the SDE user as well, but if this is the case, DO NOT DROP 'SDE' BEFORE ALL TABLES WITH SDE.ST_GEOMETRY and SDE.ST_RASTER COLUMNS! Doing so will corrupt your Oracle instance in a way that can only be "repaired" by dropping the entire database instance.
community : Delete user on arcgis server which is oracle
menghaupus user sde akan merusak data GIS secara permanen karena hilangnya register data "SDE.ST_GEOMETRY dan SDE.ST_RASTER COLUMNS"
untuk memperbaiki data di atas dengan menghapus database dan restore kembali ke waktu sebelum sde user di hapus
It is unwise to drop users before their tables have been gracefully removed from the geodatabase metadata catalogs. Best practice is to remove geodatabase-registered feature classes using ArcObjects/Python, and to remove SDE-registered tables/views using ArcObjects/Python or 'sdetable -o delete'. If you have corrupted your metadata, it is unlikely you will be able to upgrade the geodatabase before obtaining assistance from Tech Support.
The only time DROP USER ... CASCADE is really appropriate is when you're planning to drop the SDE user as well, but if this is the case, DO NOT DROP 'SDE' BEFORE ALL TABLES WITH SDE.ST_GEOMETRY and SDE.ST_RASTER COLUMNS! Doing so will corrupt your Oracle instance in a way that can only be "repaired" by dropping the entire database instance.
- [community](https://community.esri.com/t5/data-management-questions/delete-user-on-arcgis-server-which-is-oracle/td-p/476207) : Delete user on arcgis server which is oracle
menghaupus user sde akan merusak data GIS secara permanen karena hilangnya register data "SDE.ST_GEOMETRY dan SDE.ST_RASTER COLUMNS"
untuk memperbaiki data di atas dengan menghapus database dan restore kembali ke waktu sebelum sde user di hapus
It is unwise to drop users before their tables have been gracefully removed from the geodatabase metadata catalogs. Best practice is to remove geodatabase-registered feature classes using ArcObjects/Python, and to remove SDE-registered tables/views using ArcObjects/Python or 'sdetable -o delete'. If you have corrupted your metadata, it is unlikely you will be able to upgrade the geodatabase before obtaining assistance from Tech Support.
The only time DROP USER ... CASCADE is really appropriate is when you're planning to drop the SDE user as well, but if this is the case, DO NOT DROP 'SDE' BEFORE ALL TABLES WITH SDE.ST_GEOMETRY and SDE.ST_RASTER COLUMNS! Doing so will corrupt your Oracle instance in a way that can only be "repaired" by dropping the entire database instance.