Select to view content in your preferred language

delete enterprise database based on oracle

1143
1
08-14-2016 09:17 PM
yanli
by
Emerging Contributor

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?

0 Kudos
1 Reply
QuinnFrancis
Regular Contributor

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

0 Kudos