oracle aDDaa

Oracle aDDa

Pages

Showing posts with label change password by DBA. Show all posts
Showing posts with label change password by DBA. Show all posts

Sunday, 23 August 2015

User Of Oracle

Hi Friends, howz all. today  i am going to talk about users of oracle and some important terminology. let's see here.                


what is Scheema?
Scheema means users. A user in Oracle database is known as scheema an object that is created by scheemma is called scheema object. Scheema objects are like table, views, Indexes, synonyms and more.

How to connect Oracle server using client?
To connect oracle Server or database we need to open oracle client tool. lets see step by step guidence to connect oracle server.
step1 Open client(Sql*plus)
step2 Enter username
step3 Enter password
Step4 Enter DB name thet starts with @ symbol.

Note; DB name is also known as host string, Service name, SID and service ID.