My Oracle Support Banner

Dbms_metadata.get_ddl('USER') Output Exec Throws ORA-02153 When Account_status='OPEN & IN ROLLOVER' (Doc ID 2892608.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

If an account is currently in password rollover, where account_status = 'OPEN & IN ROLLOVER', executing the DDL statement generated by
dbms_metadata.get_ddl('USER', username) throws "ORA-02153: invalid VALUES password string".

select dbms_metadata.get_ddl('USER', username)
from dba_users
where account_status = 'OPEN & IN ROLLOVER';

CREATE USER "test_user" IDENTIFIED BY VALUES
'S:68AFC40ABACF8316C08D957A98E6CBAC4E7A
CD1562F896AEF24AB08EEDE6;T:9A0C060065452259217EBA61B33698CD2154B3171A5EB35DD43
C1980350ACD7B818
244D593F857DF030E2F2550A4D0C3F2D8468D4A9A7EEC811836D1AB6B132E369AEAEBF2EA58E43
22C3387BB262DBF;
t:CC7F0B2839ADC5C7C1E7FCB69609FBB4E04A7CE873876198CFFADD7EFBF9256ADC5041351AFD
D2E6418412DEC1DB
72341551F040B72F62B4D42A0E9F920E54D7369AEAEBF2EA58E4322C3387BB262DBF;V:7A725E0
38BBA3098A420CAA
EFCF165E802B673F2B33B097FFD2C47F97BCD647D7A38B13FA58A9B745A2DC4CBF949F3E390C00
1038F8DB748E0582
7EFA76AFFD35F519C7CDB80FE2EE7EE4C2F904DF5E8;s:1A139831F9EBE2FEE3500209352A809D
7789C3B762F896AE
F24AB08EEDE6;U:9066036D2595C74CD50FE4408B800E3F97A083CF62209D817A215E4FFA59;48
C7500F4D59FF40'
DEFAULT TABLESPACE "test_ts"
TEMPORARY TABLESPACE "TEMP"
PROFILE "test_profile";

*
ERROR at line 1:
ORA-02153: invalid VALUES password string



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.