SQL & PL/SQL

Good afternoon everyone:

I have an application that creates external tables on the fly. It also creates the oracle dir as well, all of which works great.

However, because of the volatile nature of the directories where the files the external tables will be using, I wanted to place the log file for all the tables created in a separate location. The main reason for doing this way is because by not having to write to the specific directory, all the oracle user needs is read rights which is the default when a directory is created.

I need to see the logs, for obvious reason, so setting the nologfile, nobadfile parameters is not an option.

So, is it possible to specify a directory rather than just a file name in the logfile parameter? Can I create an Oracle dir and use it somehow in the logfile parameter?

Any help would be appreciated.

Thanks