change LOB_SIGNATURE_ENABLE parameter on ATP database 19c
Summary
ADMIN user cant do this?Content
Hello,
I have one ATP always free DB version 19c with small APEX application. This Cloud ATP database gets data from onpremise database via dblink.
Im inserting records with BLOB to store file contents and show it in APEX application. Everything works fine until last week, when inserting LOB started to fail with error ORA-64219: invalid LOB locator encountered. I tried to solve it with SR over oracle support. I got advice - try to change database parameter LOB_SIGNATURE_ENABLE from FALSE to TRUE. The problem is how to do it. This can do only SYSKM user which is locked and to unlock it I need sys as sysdba login, that I havent. I have only ADMIN user to Cloud ATP database.
0