Database DataWarehousing (MOSC)

MOSC Banner

External Tables pointing to files on mounted drive

edited Nov 25, 2018 11:41AM in Database DataWarehousing (MOSC) 9 commentsAnswered ✓

I am trying to get our database which is running on an ODA to include external tables which are .csv files located on a different server. I have successfully mounted a network location and able to access/create/update files on the other server when SSHing into the ODA box, but when I try to connect to that server from within the database itself to read those files in as external tables, i'm receiving the following error:

ORA-03113: end-of-file on communication channel

Process ID: 12630

Session ID: 191 Serial number: 16588

Is it that the database needs it's own permissions to that mount/shared folder?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center