How do I create a user in Oracle?

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??
LVL 6
ob1_Asked:
Who is Participating?
 
Alex MatzingerConnect With a Mentor Database AdministratorCommented:
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
 
Alex MatzingerDatabase AdministratorCommented:
Make sure that your server is up and running
0
 
ob1_Author Commented:
it is i guess - i had to issue a "connect" statement and then i was able to create user.



0
 
Alex MatzingerDatabase AdministratorCommented:
sqlplus "/AS SYSDBA"
<enter your password>
Startup

Open in new window


Then you will be able to create users
0
 
Mark GeerlingsConnect With a Mentor Database AdministratorCommented:
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
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.

All Courses

From novice to tech pro — start learning today.