Thursday, December 11, 2008

My Oracle account scott is locked after i have installed oracle 10g

After you have installed oracle 10g, Most of the accounts are locked in the begining.

Try giving the following command to unlock this

Alter user scott identified by tiger account unlock