error: ORA-65096: invalid common user or role name in oracle

Ask Question

up vote24down votefavorite

13

I just installed oracle11g, and it was missing the Scott schema. So i am trying to generate it myself. I got the sql script of "Scott" schema, but when i try to run the query "create user Scott identified by tiger;" it displays the following error:

ORA-65096: invalid common user or role name in oracle.

Basically it is not allowing me to create a user "Scott". Why is that, and how can I fix my problem?

oracle oracle12c

shareimprove this question

edited Oct 25 '15 at 15:02

Lalit Kumar B

33.2k84985

asked Oct 25 '15 at 14:46

enu

182119

• 2
  That is impossible to have in 11g, you ought to be on 12c. – Lalit Kumar B Oct 25 '15 at 14:53
• Maybe you installed an 11g client, but you're connecting to a 12c database? What exactly did you install? – Alex Poole Oct 25 '15 at 15:40

add a comment

4 Answers

activeoldestvotes

up vote86down vote

Before creating the user run :

alter session set "_ORACLE_SCRIPT"=true;