I think you mean "schema" and not "database". The installer program creates a database named XE, and inside that database is a schema named HR. To create additional schemas you could use any Oracle tool like SQL*Plus or Database Control, and all you do is create a new user account (because user=schema). However, what Oracle probably prefers over SQL*Plus is that you access the XE "Home Page" on your computer using the shortcut they put on your Win2K desktop, and then click on the Administration link.
Remember the point of XE is to push Oracle Application Express, formerly HTML DB, which makes it easier to develop apps locked into Oracle, and thus push the rdbms software whose sales have been stagnant for several years. With that in mind, to create a new application schema in your XE database you should probably be using Oracle Application Express.
So you mean one can't create a new database other than the XE that's already created?
This thread http://forums.oracle.com/forums/thre...hreadID=349610, describing how you go about creating your own database. Note though that only one database can run at a time. I am still trying to follow on that thread and create my database.
Thanks a lot for your replies.
As Remidata told me, I have created a new user account, then I logged
in with that new user and could create new tables on that new schema.
Here some new questions about this.
1) I am from DB2 world, so the structure that I have in mind is.
Instance -> database -> Schema -> Table.
So Remidata, with OrXpress I can only create new schemas in existing XE database?
2) I have read what Nomthie said and what I understood is that I must
shutdown database named XE in order to have a new one.?
When I go to SQL Tool and I submit the command:
"create database oratest" it shows the following errors.
ORA-01501: CREATE DATABASE has failed
ORA-01100: database already mounted.