How to create schemas like SCOTT?
Posted on 2004-05-01
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?