Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am new to Oracle 10g xe. When I log into hr account, how do I start creating new database and insert values? My case study is a five aside football league, where the organizer wants to know following questions:

  1. alphabetical list of all the teams and their players.
  2. how many time players have been awarded player of the match?
  3. list different types of penalty points which can be awarded?
  4. produce a list of all teams playing all other teams indicating who is at home and who is away.

and lot more.

How do I start creating a new database from scratch?

share|improve this question
Just quick: the xe is a database with hr/hr schema and several others pre installed. You can start creating tables in the hr schema. – Munchi Feb 14 '13 at 19:05

You can create a new user/schema using create user clause and then start creating database tables and other objects into this schema. I would not recommend you to exploit hr schema, I would keep that schema intact and use it for testing purposes.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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