Error report - ORA-22288: FILEOPEN file or LOB operation failed ORA-06512: на "SYS.DBMS_LOB", line 805 ORA-06512: на line 12 22288. 00000 - "file or LOB operation %s failed %s" *Cause: The operation attempted on the file or LOB failed. *Action: See the next error message in the error stack for more detailed information. Also, verify that the file or LOB exists and that the necessary privileges are set for the specified operation. If the error still persists, report the error to the DBA. What i should do?
This Is local host server,how to store blob image file on database having other sever ,in this u created directoy on local drive and.it is. Acessing but in other server it is showing non existing directory, so how to load data to database table having other hostname
@@oracle_professor Yes Like that I have blob image in sys database,I want to load it on production schema that we r using. When I m creating directory in production environment and loading data getting non existing directory
Download Coding File
mabidpk.blogspot.com/p/storing-pictures-and-photos-in-oracle.html
Error report - ORA-22288: FILEOPEN file or LOB operation failed ORA-06512: на "SYS.DBMS_LOB", line 805
ORA-06512: на line 12
22288. 00000 - "file or LOB operation %s failed
%s"
*Cause: The operation attempted on the file or LOB failed.
*Action: See the next error message in the error stack for more detailed
information. Also, verify that the file or LOB exists and that
the necessary privileges are set for the specified operation. If
the error still persists, report the error to the DBA.
What i should do?
It says Lob (picture) doesn't exist.
Can you send the code used in the video? please
This Is local host server,how to store blob image file on database having other sever ,in this u created directoy on local drive and.it is. Acessing but in other server it is showing non existing directory, so how to load data to database table having other hostname
What do you mean by other servers?
Do you mean saving an image to a remote DB server?
@@oracle_professor Yes Like that I have blob image in sys database,I want to load it on production schema that we r using.
When I m creating directory in production environment and loading data getting non existing directory
can you send me the syntax?