Re: All Sample Schemas Locked and Expired

Jquest wrote:
> Hello All,
>
> Since I have installed personal oracle 9.2 with sample schemas to
> practice on.... when I see the enterprice manager ... I see the schemas
> locked and expired ... all I can do those is unlock not activate...
> need any ones help on activating and using the schemas.
>
> How do you connect to those schemas .... whats the uid and password for
> those ...
>
> thanks JQ

conn / as sysdba

alter user <schema_name> account unlock;

alter user <schema_name> identified by <new_password>;

Documented in Morgan's Library at www.psoug.org on the Users page.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org