Creating an Oracle schema/database

[Stephane Eybert]

Dear all,

I just install Oracle XE found at http://www.oracle.com/technology/software/products/database/xe/htdocs/102xelinsoft.html

I have looked at the documentation but cannot yet find how to create a database or schema.

I would like to:

- know how to list all the existing schemas

- know how to create a new schema

- grant user access rights on a schema

I need to move a database from MySql to Oracle.

I have a text dump file from MySql that I'll run in the client sql command line of Oracle as soon as I have created the recipient schema.

Thanks in advance

Stephane