I dropped the HR sample DB - now I'm lost!
819158Dec 8 2010 — edited Apr 29 2011I am using Oracle 10g XE. I wanted to completely remove the sample HR database so that I could create my own database.. So I followed these instructions:
sqlplus / as sysdba
SQL> shutdown immediate;
oracle database closed
oracle database dismounted
oracle instance shutdown
SQL> startup restrict mount;
SQL> drop database;
Database dropped
SQL> exit
So my question now is, how do I recreate a new database? Also, I am so confused - I can't even load the Oracle 10g XE Home Page. Why not? Why does a database have to exist for me to be able to open up the database admin tool? That doesn't make sense to me. I feel like I broke everything, lol. Help! Thanks.