Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Thanks Brett.
The docs are very helpful.
The issue got resolved by the below process I followed in Oracle 19c.
"maint.audit_0806test_tbr" was the table with corrupt data.
I did the below conversion on the responsible columns –
update maint.audit_0806test_tbr set OBJECT_SCHEMA=convert(OBJECT_SCHEMA,'US7ASCII','WE8ISO8859P1');
update maint.audit_0806test_tbr set OBJECT_NAME=convert(OBJECT_NAME,'US7ASCII','WE8ISO8859P1');
COMMIT;
While using the updated table maint.audit_0806test_tbr in QlikView.
Able to reload the data in QV from the temp table successfully.