title: How to create new schema and list all schema name in oracle
body: <p>I want to create one new schema in oracle and I used sample code, which is available <a href="http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_6014.htm">here</a></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 scott
  /
  </code></pre>
  
  <p>But, getting error </p>
  
  <pre><code>ERROR at line 1:
  ORA-02421: missing or invalid schema authorization identifier
  </code></pre>
  
  <p>Also, Please help me how to list name of all available schema. I am using </p>
  
  <pre><code> select username from dba_users;
  </code></pre>
  
  <p>to list schema, but i think, its not a right approach, because, user and schema has many-to-many relation,which means I can't get all schema name here.</p>
  
  <p>Please help me !!</p>