• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

problem in creating a schema

 
michell rosvlet
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I tried creating a new schema under user SYS but, later I figured it out that we cannot creating using user as SYS. So I created new user called LEARNER and logged in using LEARNER and tried creating it it gives me this following error
ORA-02421: missing or invalid schema authorization identifier

Can anyone tell me where I am going wrong.
 
Fatih Keles
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Michell,

Creating a user also creates a schema. You may find this useful. What are you planning to achieve by using create schema?

Regards,

Fatih.
 
Vinod Tiwari
Ranch Hand
Posts: 466
1
IntelliJ IDE Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does user LEARNER have priviledges to create Schema??
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic