delete enterprise database based on oracle

yanli — Mon, 15 Aug 2016 04:17:17 GMT

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?

Re: delete enterprise database based on oracle

QuinnFrancis — Wed, 31 Aug 2016 12:38:19 GMT

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

topic delete enterprise database based on oracle in Data Management Questions

delete enterprise database based on oracle

Re: delete enterprise database based on oracle