This content has been marked as final. Show 4 replies
Pl post details of OS and database versions, along with what you mean by "local file system". The log file directory for the external table is determined in the definition of the external table - if this directory is a shared directory that he "local file system" has access to, your requirement can be met in theory. Security and other considerations may prevent such an implementation.
Only if you can map a directory object on the server that points to your local drive. And if your DBA allows you to do that I will be very surprised.
Instead ... put the log file at the same location as the external table ... then create another external table that points to the log file. A simple SELECT * FROM will allow you to read the log file at will.