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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
pratikroyConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.