Showing posts with label SCOTT user. Show all posts
Showing posts with label SCOTT user. Show all posts

Tuesday, July 9, 2013

How to unlock SCOTT account in Oracle 10g

Hi,

Oracle Corporation by default will provide the SCOTT user with tiger as password. Scott is the best user for beginners in Oracle. SCOTT User is providing the tables like EMP, DEPT which are having complex logic. As a Oracle beginners we can practice more on the Scott user table improve our knowledge in Oracle. So here I wanna show you how to unlock the SCOTT user, if it is locked by default.
When you are logging into the SCOTT user you may get errors like

ERROR:
ORA-28000: the account is locked.