ob1_
asked on
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??
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??
Make sure that your server is up and running
ASKER
it is i guess - i had to issue a "connect" statement and then i was able to create user.
sqlplus "/AS SYSDBA"
<enter your password>
Startup
Then you will be able to create users
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.