Create Schema in Oracle 11g

Question

I am trying to create a new Schema in Oracle 11g.

I have referred to the Oracle documentation

I have tried to execute the commands mentioned there.

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;

I am getting the following error when I run this commands in Eclipse.

ORA-02421: missing or invalid schema authorization identifier (0 rows affected)

Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.

Anybody has an idea why this is happening ?

Thank you.

score 4 · Answer 1 · answered May 29 '13 at 10:22

4

Go to Command Prompt. Login as System and Password as orcl

SQL> create user [username] identified by [password];

User created.

SQL> grant create session to [username];

Grant succeeded.

SQL> grant create table to [username];

Grant succeeded.

SQL> create role developer;

Role created.

SQL> grant developer to [username];

Grant succeeded.

SQL> grant resource to [username];

answered May 29 '13 at 10:22

user1256936

141
2
4

I think this is the better answer regarding creating schema, in Oracle schema = user. – Tuyen Nguyen Jul 18 '13 at 05:35

score 4 · Accepted Answer · answered Jan 17 '12 at 21:29

4

At at a guess, I'd say you're not logged in as user oe (which the docs you reference say you must be).

Also see the description of the error you're getting.

answered Jan 17 '12 at 21:29

Gerrat

28,863
9
73
101

Create Schema in Oracle 11g

2 Answers2