I have site up enterprise database based on oracle and run successfully with arcgis server 10.3.1 ,but i wan't to create a enterprise database base on PostgreSQL now, how to delete the enterprise database and based on oracle with the sde connection?
Hi Yan,
There is no way to delete the Oracle database via ArcCatalog or any other esri tools. The database connection in ArcCatalog is merely an SDE connection file that is stored on the machine making the connection to the server machine. In order to delete the database you will need to use Oracle tools to do so. You can achieve this by running Database Configuration Assistant (DBCA) or by using the DROP DATABASE statement in an Oracle developer program (SQL Plus, SQL Developer, TOAD, etc.).
DROP DATABASE
Quinn
Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.