CODEWITHSUNDEEP
oracle11g
user1451111
user1451111

Reputation: 1943

insufficient privileges for Scott user in Oracle for creating table

I installed Oracle 11g and I am trying to CREATE TABLESPACE using user 'Scott' but I am getting "insufficient privileges". What should I do ? I am connected to SQL Developer using 'Scott' user.

Upvotes: 0

Views: 480

Answers (1)

Lalit Kumar B
Lalit Kumar B

Reputation: 49062

You cannot do CREATE TABLESPACE without SYSTEM privilege. It is a prerequisite.

From documentation -

You must have the CREATE TABLESPACE system privilege.

Upvotes: 1

Related Questions