Forum Stats

  • 3,826,586 Users
  • 2,260,667 Discussions
  • 7,897,010 Comments

Discussions

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

User_PP11O
User_PP11O Member Posts: 3 Green Ribbon

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

Best Answers

  • Solomon Yakobson
    Solomon Yakobson Member Posts: 19,473 Red Diamond
    edited Mar 14, 2022 11:04AM Answer ✓
    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
    BluShadow Member, Moderator Posts: 41,978 Red Diamond

    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)

Answers

  • User_PP11O
    User_PP11O Member Posts: 3 Green Ribbon

    also checked with oracle:oinstall permission.

  • Solomon Yakobson
    Solomon Yakobson Member Posts: 19,473 Red Diamond
    edited Mar 14, 2022 11:04AM Answer ✓
    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
    BluShadow Member, Moderator Posts: 41,978 Red Diamond

    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
    User_PP11O Member Posts: 3 Green Ribbon

    Hi Guys,


    Thanks for the info.


    Giving Permission on each directory resolved the issue.


    Regards,

    Yagnik

  • Solomon Yakobson
    Solomon Yakobson Member Posts: 19,473 Red Diamond
    edited Mar 14, 2022 12:44PM

    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.