Search code examples
databaseschemasqlplusoracle-xe

Drop Database Schema and all tables in OracleXE

I'm very confused, since I've tried a lot of tuts online, but still there are errors or inconsistencies in the schema when i try to drop a User\Database through SqlPlus.

Every time I need to relaunch, for example, a dll through script, I need a blank schema\user, so I'm forced to reinstall OracleXE to obtain this!

Can anybody share some light here?

thx

Solution 
  • Drop user user_name cascade;

    use the above command while logging in sys as sysadmin, and this will delete the schema/user name which deletes all the tables