Question: I have installed oracle 10g express edition and I did not find the option to 
 create schema..

Is there a option to create schema in oracle 10g express edition
 or else I have to install other oracle 10g..?

To create schema which oracle 10g
 I have to install... what?

Answer: 
You don't need to explicitly create schema, Oracle automatically creates a schema when you create a user (see **[`CREATE USER`](http://download.oracle.com/docs/cd/B13789_01/server.101/b10759/statements_8003.htm#i2065278)** documentation). 

If you really want, you can use [**`CREATE SCHEMA`**](http://download.oracle.com/docs/cd/B13789_01/server.101/b10759/statements_6013.htm) statement and issue it through Oracle Express web interface or from SQL prompt.
The `CREATE SCHEMA` statement can include `CREATE TABLE`, `CREATE VIEW`, and `GRANT` statements. To issue a `CREATE SCHEMA` statement, you must have the privileges necessary to issue the included statements.

```
CREATE SCHEMA AUTHORIZATION oe
   CREATE TABLE new_product 
      (color VARCHAR2(10)  PRIMARY KEY, quantity NUMBER) 
   CREATE VIEW new_product_view 
      AS SELECT color, quantity FROM new_product WHERE color = 'RED' 
   GRANT select ON new_product_view TO hr; 

```