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...