RE: Trace files of large sizes are getting generated
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: "nileshkum@xxxxxxxxx" <nileshkum@xxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 6 Nov 2009 08:56:25 -0700
Looks like maybe someone changed the permissions on the files/directories
mentioned in your stp_snr_ne_load_xml procedure shown below. Did you make sure
the oracle user has permissions to read them?
Regards,
Brandon
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of nilesh kumar
ORA-22288: file or LOB operation FILEOPEN failed
Permission denied
DB.stp_snr_ne_load_xml('NE_CMPNY_STORY_LINK_ST','200910240444NYT_____NEWS_____387932_1490.3.xml','NEWSEDGEISSUE.xsl','NEWSEDGE_XML_SOURCE_DIR','NEWSEDGE_XSL_SOURCE_DIR');
________________________________
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
Other related posts: