CODEWITHSUNDEEP
sqldatabaseoracle-databaseoracle10g
Tom
Tom

Reputation: 771

How to Create a user in oracle on database name

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

Upvotes: 0

Views: 252

Answers (1)

Gergely Bacso
Gergely Bacso

Reputation: 14651

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

Upvotes: 1

Related Questions