Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1743
  • Last Modified:

How to create schemas like SCOTT?

How to create Schemas? I mean, I'm trying to create a schema using Oracle Enterprise Manager Console, but no success.  I need to create a schema named OP, like SCOTT with a user with same name. Using Oracle Enterprise Manager and login as System, first I created a tablespace named OP. It's been created C:\Oracle\OraData\MyData\OP.ORA as well. Then I created a user named OP. I checked the object tree, but there's no OP schema. How can I achieve that, please?
0
miyahira
Asked:
miyahira
  • 2
1 Solution
 
pratikroyCommented:
You have successfully created the schema for the user OP. You could not see OP in the default schema view because you dont have any objects created in the OP schema. Try creating a table in OP schema. Once created, you can see the schema in the tree.

Hope this helps.
0
 
pratikroyCommented:
Note that After you create any object in the newly created schema (OP), you will have to refresh, to see the name of OP schema in the tree.
0
 
oleggoldCommented:
oem is fine,try this
sqlplus /nolog
connect / as sysdba
create user op identified by op;
grant connect,resource to op;
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now