how to create user/ schema in oracle database?

creating schema or user in oracle 12c database:
 1. first we have to connect the oracle database, connecting to oracle can be in two ways. one is through command prompt and another one is through SQL Developer.
2. using command prompt:
3. using SQL developer
4. click on SQL developer,
5. you will get Oracle SQL Developer window, in that you have to give new connection
6. after giving connection name and username, password and your service name or database name there, and then click on connect.
7. connection established.now you are able to create new schema or user
8. after creating user you have to give some grants and permissions to that scheme.
creating schema or user done.








Comments