Prev: im004 oracle odbc error with unprivileged users
Next: Urgent help needed!
From: Björn Wächter on 8 Sep 2006 05:00
Hi all,

I'm facing a strange problem. I'm executing these commands
in my Oracle 10.2 Database running on debian linux.


This one is working very well:

utl_file.frename(
src_location => v_source_dir,
src_filename => p_s_filename,
dest_location => v_destination_dir,
dest_filename => p_s_filename,
overwrite => TRUE
);


But when I execute this command with exactly the same
filenames and directory names like in frename:

utl_file.fcopy(
src_location => v_source_dir,
src_filename => p_s_filename,
dest_location => v_destination_dir,
dest_filename => p_s_filename
);

I'm getting an ORA-29284 file read error.

As fare as I know linux. If a can move a file, there is no
reason why copy should fail. The file is not existing in the
destination location, so the overwrite => TRUE can not be the
reason.
Any ideas?

Thanks Bj?rn
From: Martin T. on 8 Sep 2006 05:22
Björn Wächter wrote:
> Hi all,
>
> I'm facing a strange problem. I'm executing these commands
> in my Oracle 10.2 Database running on debian linux.
>
>
> This one is working very well:
>
> utl_file.frename(
> src_location => v_source_dir,
> src_filename => p_s_filename,
> dest_location => v_destination_dir,
> dest_filename => p_s_filename,
> overwrite => TRUE
> );
>
>
> But when I execute this command with exactly the same
> filenames and directory names like in frename:
>
> utl_file.fcopy(
> src_location => v_source_dir,
> src_filename => p_s_filename,
> dest_location => v_destination_dir,
> dest_filename => p_s_filename
> );
>
> I'm getting an ORA-29284 file read error.
>
> As fare as I know linux. If a can move a file, there is no
> reason why copy should fail. The file is not existing in the
> destination location, so the overwrite => TRUE can not be the
> reason.
> Any ideas?
>

Apologies for not being that helpful, but:
* On windows I have noticed that a rename will often work when nothing
else would work (not saying it will be anything alike on Linux).
* Have you tried doing the same thing with a shell script under the
user oracle runs? Does it work there?

best,
Martin

From: DA Morgan on 8 Sep 2006 08:56
Bj?rn W?chter wrote:
> Hi all,
>
> I'm facing a strange problem. I'm executing these commands
> in my Oracle 10.2 Database running on debian linux.
>
>
> This one is working very well:
>
> utl_file.frename(
> src_location => v_source_dir,
> src_filename => p_s_filename,
> dest_location => v_destination_dir,
> dest_filename => p_s_filename,
> overwrite => TRUE
> );
>
>
> But when I execute this command with exactly the same
> filenames and directory names like in frename:
>
> utl_file.fcopy(
> src_location => v_source_dir,
> src_filename => p_s_filename,
> dest_location => v_destination_dir,
> dest_filename => p_s_filename
> );
>
> I'm getting an ORA-29284 file read error.
>
> As fare as I know linux. If a can move a file, there is no
> reason why copy should fail. The file is not existing in the
> destination location, so the overwrite => TRUE can not be the
> reason.
> Any ideas?
>
> Thanks Bj?rn

Just a couple of thoughts.

ls -la and verify your permissions on the file.

Replace your variables with hard coded strings and see if the problem
continues.
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
 | 
Pages: 1
Prev: im004 oracle odbc error with unprivileged users
Next: Urgent help needed!