Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Loader - Unable to open File

637272Mar 11 2009 — edited Mar 11 2009

Hi guys,

Oracle version: Oracle9i Enterprise Edition Release 9.2.0.7.0

I'm trying to read a txt file using SQL*Loader. When the file is at my local machine, where SQL*Loader (and Oracle Client) is installed, the process works fine. But, when I try to read the same file from a network directory, it doesn't work and I get the following messages at the end of the log file:

SQL*Loader-500: Unable to open file (\\<<network directory>>\<<filename>>)
SQL*Loader-552: insufficient privilege to open file

I'm not sure if it's a problem of the SQL*Loader or if the problem is that Oracle is not able to read the directory where the file is in.

Please, could you help me?

Regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 8 2009

Added on Mar 11 2009

#database-key-features, #export-import-sql-loader-external-tables

1 comment

1,979 views