Create Schema in oracle 10g express edition

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 1

You don't need to explicitly create schema, Oracle automatically creates a schema when you create a user (see CREATE USER documentation).

If you really want, you can use CREATE SCHEMA statement and issue it through Oracle Express web interface or from SQL prompt.

Answer 2

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;