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
Joined: Sep 01, 2005
Posts: 172
posted
0
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
Joined: Feb 06, 2008
Posts: 356
posted
0
Does user LEARNER have priviledges to create Schema??