Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Operation Failed ORA-22288 Target Altered

Kashif IftikharFeb 19 2021

Hi,
Im using Oracle 12c (12.2.0.1) on Oracle Linux 7.6.
I'm using a plsql procedure to save a file into DB. this procedure is executing from within my application. its syntex is like DBMS_LOB.FILEOPEN (Lob_loc, DBMS_LOB.FILE_READONLY).
physical file is placed on a NFS share mounted on my machine
application is behaving very strangely. some times procedure executed successfully and sometime it throw following error:-
Operation Failed ORA-22288 File OR LOB operation FILEOPEN failed Target Altered ora-06512
I have google this error but did not find a single link discussing "Target Altered" which is specific description of FILEOPEN operation fail error.

please help,
Regards.

Comments
Post Details
Added on Feb 19 2021
1 comment
316 views