文件操作无效 [英] invalid file operation

问题描述

使用以下代码时获取无效的文件操作。

我在客户端计算机上运行此操作并创建了一个名为''DEEPS'的导演并且已经给予读/写权限运行以下quries用于设置路径。


如果我无法在客户端计算机上运行此功能。请帮助我从.txt文件中读取数据并使用UTL包更新到数据库中。


请帮助

Getting invalid file operation when using the below code.
Iam running this on client machine and have created one director by name ''DEEPS'' and have given read/write privileges ran the below quries for setting path.

If i cannot run this porcedure on client machine. please help me for reading data from .txt file and updating into database with out using UTL packages.

Please help

展开 | 选择 | Wrap | 行号

推荐答案

有人可以建议，因为我需要通过EOD执行此操作

Can someone please suggest as i need to do this by EOD

@raagadeepthi

您好raagadeepthi，


验证文件和目录访问权限p文件系统上的文件系统，如果阅读，请确认该文件是否存在。

你执行了以下命令吗？

假设你试图从''/中读取文件tmp''和你在直接传递''ORADIR''。

CONNECT / AS SYSDBA

创建或替换DIRECTORY ORADIR作为''/ tmp'';

GRANT读取，写入目录ORADIR到scott;


执行此操作后，如果再次出现错误，请检查文件是否存在于/ tmp中以及完全访问权限对于Oracle用户来说。


种类Regds，

Bhushan

@raagadeepthi
Hi raagadeept

Verify file and directory access privileges on the file system, and if reading, verify that the file exists.
Have you executed below command?
Let say ur trying to read a file from ''/tmp'' and ur passing ''ORADIR'' in direc .
CONNECT / AS SYSDBA
CREATE OR REPLACE DIRECTORY ORADIR AS ''/tmp'';
GRANT read, write ON DIRECTORY ORADIR TO scott;

After doing this if you get error again then please check whether file does exists into /tmp or not and full access to Oracle user on that.

Kind Regds,
Bhushan

无效的文件操作可能由于几个原因喜欢：


1.目录中不存在文件

2.你没有对特定文件的读写访问权

您能否检查以上两点并回复。另外请检查目录是否到位，并且您具有使用目录所需的权限。


注意：我上面说的目录是我所指的逻辑目录需要创建使用CREATE DIRECTORY语句

Invalid File opertaion can be due to few reasons like:

1. file does not exist in the directory
2. you dont have read write access on the particular file

Can you please check on above two points and post back. Also please check that the Directory is in place and you have required privileges to use the DIRECTORY.

Note: The directory that I am talking above is logical directory that I am refering to that we need to create using CREATE DIRECTORY statement

这篇关于文件操作无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！