title: Create Schema in Oracle 11g
body: <p>I am trying to create a new Schema in Oracle 11g.</p>
  
  <p>I have referred to the <a href="http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_6014.htm" rel="nofollow">Oracle documentation</a></p>
  
  <p>I have tried to execute the commands mentioned there.</p>
  
  <pre><code>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; 
  </code></pre>
  
  <p>I am getting the following error when I run this commands in Eclipse.</p>
  
  <p><em><strong>ORA-02421: missing or invalid schema authorization identifier
  (0 rows affected)</em></strong></p>
  
  <p><em><strong>Elapsed Time:  0 hr, 0 min, 0 sec, 0 ms.</em></strong></p>
  
  <p>Anybody has an idea why this is happening ? </p>
  
  <p>Thank you.</p>