<div>
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.
</div>


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.

<div>
oem is fine,try this<br />
sqlplus /nolog<br />
connect / as sysdba<br />
create user op identified by op;<br />
grant connect,resource to op;<br />

</div>


oem is fine,try this
sqlplus /nolog
connect / as sysdba
create user op identified by op;
grant connect,resource to op;


<div>
<div class="content wysiwyg-content">
How to create Schemas? I mean, I'm trying to create a schema using Oracle Enterprise Manager Console, but no success. &nbsp;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\O<wbr />P.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?
</div>
</div>


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?

How to create schemas like SCOTT?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.