Solved

How do I create a user in Oracle?

Posted on 2011-02-11
5
505 Views
Last Modified: 2012-05-11
I have installed a new Oracle server. I am trying to create a user so I can import a database (DMP file).

I am using this command: "create user SAMPLE identified by password;" but it comes back with "SP2-0640 - Not connected".

how do I create user so I can import database from DMP file??
0
Comment
Question by:ob1_
  • 3
5 Comments
 
LVL 4

Expert Comment

by:Alex Matzinger
Comment Utility
Make sure that your server is up and running
0
 
LVL 6

Author Comment

by:ob1_
Comment Utility
it is i guess - i had to issue a "connect" statement and then i was able to create user.



0
 
LVL 4

Expert Comment

by:Alex Matzinger
Comment Utility
sqlplus "/AS SYSDBA"
<enter your password>
Startup

Open in new window


Then you will be able to create users
0
 
LVL 4

Accepted Solution

by:
Alex Matzinger earned 250 total points
Comment Utility
That makes sense.  I had forgotten the connect command.

If you need help importing the dmp file here is a link that can guide you.  Otherwise, GL.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#i1023560
0
 
LVL 34

Assisted Solution

by:Mark Geerlings
Mark Geerlings earned 250 total points
Comment Utility
You may not need to create a user first, depending on how the *.dmp file was created.  If that was a whole-database export, it will create the user(s) for you.  If however you have a schema-level or table-level export file, then you will need to create the user first.

Another problem could be the tablespace(s) and/or datafile(s) in the export file.  When you run import, Oracle will assume that your disk and directory structure in this server is the same as it was in the server where the export file was created.  But, that may or may not be true for you.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to recover a database from a user managed backup
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

763 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