Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I dropped the HR sample DB - now I'm lost!

819158Dec 8 2010 — edited Apr 29 2011
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2011
Added on Dec 8 2010
3 comments
823 views