Solved

How do I create a user in Oracle?

Posted on 2011-02-11
5
512 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
ID: 34873380
Make sure that your server is up and running
0
 
LVL 6

Author Comment

by:ob1_
ID: 34873392
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
ID: 34873393
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
ID: 34874058
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 35

Assisted Solution

by:Mark Geerlings
Mark Geerlings earned 250 total points
ID: 34876801
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

820 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