Re: problem in choose schme created to work

"mammo_2778" <mynamesittipat_at_yahoo.com> wrote...
> Hi I am new comer of oracle. I have question that i create 2 schma 1st
> named is my_work and password is something1, and I created another
> schema create password to another one. So problem is I want to back to
> use 1st schema but I can't login to 1st schema, can use only username
> and password of 2nd schema

I think you've made a typo when you created the first user account. To reset the password follow these steps.

1. Log in as a user which has ALTER USER system privilege.
2. Then you can alter your user using this statement: ALTER USER my_work IDENTIFIED WITH something1;

hth,
Guido Received on Thu Apr 24 2003 - 03:31:36 CDT