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?
LVL 1
miyahiraAsked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.