Improve company productivity with a Business Account.Sign Up

x
?
Solved

How to create schemas like SCOTT?

Posted on 2004-05-01
3
Medium Priority
?
1,747 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 340 total points
ID: 10969771
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
ID: 10969779
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
ID: 10971070
oem is fine,try this
sqlplus /nolog
connect / as sysdba
create user op identified by op;
grant connect,resource to op;
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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.

Join & Write a Comment

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

588 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