The moose likes Oracle/OAS and the fly likes problem in creating a schema Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Products » Oracle/OAS
Reply Bookmark "problem in creating a schema" Watch "problem in creating a schema" New topic
Author

problem in creating a schema

michell rosvlet
Greenhorn

Joined: May 22, 2009
Posts: 23
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
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
Does user LEARNER have priviledges to create Schema??


Vinod Tiwari | Facebook | LinkedIn | Twitter
 
 
subject: problem in creating a schema
 
MyEclipse, The Clear Choice

cast iron skillet 49er

more from paul wheaton's glorious empire of web junk: cast iron skillet diatomaceous earth rocket mass heater sepp holzer raised garden beds raising chickens lawn care CFL flea control missoula heat permaculture