How to Create a user in oracle on database name

Question

I am new to oracle, i want to create a user named as abc in oracle database, but i do n't know how to do it, please help me. My database name is tom. I wrote the following

create user abc identified by abc. But how can i link this user to my database tom?

After the user creation, I want to import a dmp file in that user, how can i import on user abc?

Any help is much appreciated

Firstly, this is a Q&A format, one question at a time please. Secondly, you must have logged in to a database to be able to issue the CREATE USER command. If you didn't log in to your tom database, where have you logged into? — Ollie
– Ollie, Commented Jun 26, 2012 at 10:48
if you are at all serious about learning Oracle, why not start with Oracle's own documentation? Start with oracle.com/pls/db111/homepage or try googling. — tbone
– tbone, Commented Jun 26, 2012 at 10:54

Gergely Bacso · Accepted Answer · 2012-06-26 10:56:38Z

1

Your original statement is correct. You can create a new user (using an existing admin user) like this:
create user user_name_u by identified by password_p;

Importing procedure can be different based on what kind of client are you using. But you surely have an SQLPlus, so this have to be enough:
http://www.orafaq.com/wiki/Import_Export_FAQ

answered Jun 26, 2012 at 10:56

Gergely Bacso

14.7k2 gold badges46 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Create a user in oracle on database name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related