change account status from expired to open

change account status from expired to open:

SQL> select username,account_status from dba_users where account_status='EXPIRED';

USERNAME       ACCOUNT_STATUS
------------- -----------------  
AUTO_CATT8     EXPIRED

SQL> set long 9999999
SQL> set pages 333 lines 222
SQL> select dbms_metadata.get_ddl('USER','AUTO_CATT8') from dual;

DBMS_METADATA.GET_DDL('USER','AUTO_CATT8')
--------------------------------------------------------------------------------
CREATE USER "AUTO_CATT8" IDENTIFIED BY VALUES 'S:54C1468D29B1759BEF943066549E
4A6583425459428A27280143EEA3872266D9;T:BEC38C394DD6D61E87D51FD0E9C1685C949C8B9CA2F32
DB3626C7F16DE927C91D95FBB0F358AEA2100B5E8251F60C331B6173EAC91530BF3BF0EE84ECF9AB
C3486A6D17F81BF2848F33AA7FE97BB0704'
      DEFAULT TABLESPACE "AUTOMATION"
      TEMPORARY TABLESPACE "TEMP"
      PASSWORD EXPIRE

SQL> alter USER "AUTO_CATT8" IDENTIFIED BY VALUES 'S:54C1468D29B1759BEF943066549E4A658AEA095A27280626C7143EEA3872266D9;T:BEC38C394DD6D61E87D51FD0E9C1685C949C8B9CA2F32DB32452334C91D95FBB0F358AEA2100B5E8251F60C331B6173EAC91530BF3BF0EE84ECF9ABC3486A6D17F81BF2848F33AA7FE97BB0704';

 User altered.

SQL> select username,account_status from dba_users where username='AUTO_CATT8';

USERNAME       ACCOUNT_STATUS
------------- -----------------
AUTO_CATT8     OPEN

Comments

Popular posts from this blog

How to set the root password after creating instance on oracle cloud

TNS-12541 TNS-12560 TNS-00511 TNS:protocol adapter error No listener

Queryable inventory could not determine the current opatch status.