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.

Gerrat · Accepted Answer · 2012-01-17 21:29:47Z

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, 2012 at 21:29

Gerrat

29.9k9 gold badges78 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user1256936 · Accepted Answer · 2013-05-29 10:22:08Z

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, 2013 at 10:22

user1256936

1412 silver badges4 bronze badges

1 Comment

Tuyen Nguyen Over a year ago

I think this is the better answer regarding creating schema, in Oracle schema = user.

Collectives™ on Stack Overflow

Create Schema in Oracle 11g

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related