My Oracle XE database was useless mess of unused tables etc. Using SqlPlus and several google results, I finally managed to drop the XE database, but now when I connect with SqlPLus IO cannot create a database. For any CREATE DATABASE command issue, I get back the error ORACLE not available.

I assume this is as I deleted the only db on that server, which only has room for one db, SqlPlus now gets confused as to how to connect, still trying to find XE. How can I connect as admin without connection to a db. so that I am connected to Oracle but not to a db? This seems to new the most likely solution.

  • 1
    Your best bet is to wipe and reinstall Oracle XE, probably following some tutorial from Oracle, as you seem to be missing few important Oracle concepts.
    – mustaccio
    Dec 12 '19 at 19:56
  • 1
    %Oracle_home%\deinstall\deinstall.bat is your best friend in this case.
    – John K. N.
    Dec 13 '19 at 13:42

You should have dropped the owners (AKA schemas AKA users that created the tables) of the "mess of unused tables." If you dropped the database, no way to restore it (unless you have a backup). Just recreate the database. And in the future you can drop just the non-system users, like to drop the Oracle Sample schema SCOTT:

drop user SCOTT cascade;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.