Home » SQL & PL/SQL » SQL & PL/SQL » ORA-22288: file or LOB operation FILEOPEN failed
ORA-22288: file or LOB operation FILEOPEN failed [message #325385] Fri, 06 June 2008 01:48 Go to next message
thread_Oracle
Messages: 4
Registered: June 2008
Junior Member
I am getting the following error
ORA-22288: file or LOB operation FILEOPEN failed


Please tell me what permissions need to be set to modify in the oracle 10gAS

Thanks in advance
Re: ORA-22288: file or LOB operation FILEOPEN failed [message #325389 is a reply to message #325385] Fri, 06 June 2008 02:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-22288: file or LOB operation %s failed\n%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.

Regards
Michel
Re: ORA-22288: file or LOB operation FILEOPEN failed [message #325421 is a reply to message #325389] Fri, 06 June 2008 02:57 Go to previous messageGo to next message
thread_Oracle
Messages: 4
Registered: June 2008
Junior Member
Hi Michel Cadot

Thanks for your reply

this is the full error message

ORA-22288: file or LOB operation FILEOPEN failed
The system cannot find the path specified.
ORA-06512: at "SYS.DBMS_LOB", line 716
ORA-06512: at line 6

how to solve this problem please help me

[Updated on: Fri, 06 June 2008 02:59]

Report message to a moderator

Re: ORA-22288: file or LOB operation FILEOPEN failed [message #325424 is a reply to message #325421] Fri, 06 June 2008 03:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Make the system able to find the file?

Regards
Michel
Re: ORA-22288: file or LOB operation FILEOPEN failed [message #325505 is a reply to message #325424] Fri, 06 June 2008 07:31 Go to previous message
thread_Oracle
Messages: 4
Registered: June 2008
Junior Member
hi Michel Cadot

Its working i gave my directory path wrongly so it was not recognising then

thanks for your reply
Previous Topic: cluster index
Next Topic: use of sequence
Goto Forum:
  


Current Time: Mon Feb 10 11:49:46 CST 2025