Search code examples
oracle-databaseoracle12c

Can you reset/retrieve a username/password used in schema creation of a desktop Oracle database?

I have an Oracle 12C desktop database schema I created some time ago. I don't remember the username/password for when I created the schema.

Is there any way to retrieve it? I have full admin privileges for computer.

Thanks much.

Solution

  • Login as SYS (I suppose you are still able to do that) and then issue:

    alter user <<schema>> identified by <<new_password>>;