External table created to read files residing on another server.
Below are the sequence of events I've done to try selecting an external table that have files residing on another server. But I encountered some problems. Appreciate if I can get some pointers to solve the challenge i faced.
(1) I created and shared out a folder on a non-db server to store all the flat files meant for my data processing.
(2) I then create a directory in my db to point to that shared folder.
(3) After which, i created an external table to read a file that are placed in the shared folder. However, I encountered the below errors: