KUP-04040: file ACTMSAT.CSV in TEST not found.

User_PP11O

Hello,

I'm Creating external table in dbcs instance but getting KUP-04040 error.

Which means that file is not found in directory.

Database directory, Path, Permission on directory and files is fine but still getting the error.

-rwxrwxrwx 1 oracle dba 456130 Mar 14 15:33 ACTMAST.CSV

Same syntex and files working fine in local database.

am i missing anything?

Thanks in advance.

Regards,

Yagnik

Solomon Yakobson

1. Sanity check: directory is located on database server or can be accessed from it.
2. OS user oracle has read permission on each directory on the path.

SY.

BluShadow

And just to stress what Solomon says...

1. OS user oracle has read permission on each directory on the path.

3rd sanity check would be...

3. You are logged on to a database that's on that actual database server?

(So often people have put the file on one server and forgotten they've logged on to a different "test" account which is on another server)

User_PP11O

also checked with oracle:oinstall permission.

Solomon Yakobson

1. Sanity check: directory is located on database server or can be accessed from it.
2. OS user oracle has read permission on each directory on the path.

SY.

BluShadow

And just to stress what Solomon says...

1. OS user oracle has read permission on each directory on the path.

3rd sanity check would be...

3. You are logged on to a database that's on that actual database server?

(So often people have put the file on one server and forgotten they've logged on to a different "test" account which is on another server)

User_PP11O

Hi Guys,

Thanks for the info.

Giving Permission on each directory resolved the issue.

Regards,

Yagnik

Solomon Yakobson

Os user oracle MUST have read permission on /home directory, /home/oracle directory and /home/oracle/excel directory. If /home is owned by root then world must have read on /home (or oracle must have read via ACL). Anyway, post create external table statement. Also, login as external table owner and post results of:

SELECT * FROM USER_TAB_PRIVS WHERE TABLE_NAME = 'your-external-table-directory-object-name'

SY.