1 Reply Latest reply: Apr 11, 2013 1:26 PM by Jason_(A_Non) RSS

    SQL Error: ORA-22288: file or LOB operation FILEOPEN failed

    1002073
      Hi,
      I try to import xml file in table. I create directory CREATE DIRECTORY XML_DIR1 AS 'C:\NEW' then i try to import

      insert into BINARY_XML_TABLE values (XMLTYPE(BFILENAME ('XML_DIR1','test.xml'),nls_charset_id('AL32UTF8'))); and i get
      Error report:
      SQL Error: ORA-22288: file or LOB operation FILEOPEN failed
      The system cannot find the file specified.
      ORA-06512: at "SYS.XMLTYPE", line 296
      ORA-06512: at line 1
      22288. 00000 - "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.

      I use personal edition oracle 11g on windows 8
      Thank you