Hey Mark,

The database is gone. Nothing exists. I've even deleted all directories. This is just a development workstation. I don't think the problem has nothing to do with Oracle at this point. There must to be a way to remove a service from Windows or from the command line.

Thanks,
Will

>>Hello,
>>
>>I have a service that no longer exists. An Oracle database which was deleted and the Oracle application never removed the service. The problem is now I am recreating the database with the same name and Oracle is telling me the database already exists but it doesn't.
>>
>>How do I remove the service manually?
>>
>>Thanks,
>>Will
>
>I think you need to get more information on just what exactly happened. Did the Oracle DBF file get deleted via the OS? This is absolutely the wrong thing to do. What exactly got deleted?
>
>Hopefully, the removal process involved dropping the tables while in Oracle [e.g., using SQL Plus, Enterprise Manager, etc.] as well as all the other non-system objects in the database. Then you have to make sure no user has the tablespace set as their default TS, no indexes use this TS, etc. Then you can drop the tablespace. This will remove the Oracle DBF file.