Database Administration (MOSC)

MOSC Banner

External table created to read files residing on another server.

edited Jul 19, 2010 9:25AM in Database Administration (MOSC) 5 commentsAnswered
Dear all,

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:

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