Solved

How to create schemas like SCOTT?

Posted on 2004-05-01
3
1,729 Views
Last Modified: 2008-03-06
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
Comment
Question by:miyahira
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
pratikroy earned 85 total points
Comment Utility
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
 
LVL 9

Expert Comment

by:pratikroy
Comment Utility
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
 
LVL 21

Expert Comment

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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now