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
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