A reader, April 08, 2024 - 6:56 am UTC
During the database conversion using DMU ,
below query executing
UPDATE SYS.SQLOBJ$PLAN set OTHER_XML =SYS_OP_CSCONV(OTHER_XML,'AL16UTF16')
and i need to check how many clob rows converted to AL16UTF16 .
is any query or function available .
April 09, 2024 - 4:38 am UTC
Assuming it updated every row, would not
select count(*) from SYS.SQLOBJ$PLAN
suffice?