I just installed Oracle, 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?