0

How to read a file present in application server using external tables. I can't place the file in DB server as we are restricted from DB server.

Sathyajith Bhat
  • 21,321
  • 22
  • 95
  • 134
kanna
  • 101
  • 7

1 Answers1

2

According to the documentation, the data file for an external file must be visible to the server.

You access an external file via a DIRECTORY object in the database, which points to a directory on the db server.

Now, you can mount a drive so that it appears in the file system, but someone with access to the db server will probably have to do that.

eaolson
  • 14,717
  • 7
  • 43
  • 58