Some imp SQL DBA tricks

get into cmd
go to c:>
enter sqlplus "/ AS sysdba"

ex: c:> sqlplus "/ AS sysdba"

sql:> show user

user name will be displayed

sql:> passw system

-----------------------------------

To get the scott account unlocked
'
login as "system" user

sql:> alter user scott account unlock;

sql:> passw scott

____________________________________________


to set the line size

sql:> set linesize 100;

____________________________________________

to grant permissions to users

login as sysdba

sql:> connect /as sysdba

sql:> grant all privileges to scott;

_____________________________________________