delete enterprise database based on oracle

856
1
08-14-2016 09:17 PM
Highlighted
by
New Contributor II

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?

Reply
0 Kudos
1 Reply
Highlighted
New Contributor III

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

Reply
0 Kudos