Reading file from oracle directory at client side

fehers

Hi,

I have a SWING app. which connects to an Oracle db.

My goal is to read files from oracle directory with java through JDBC. I export some dumps with datapump and they need to be transferred to a client machine. There is no access to oracle directory at network filesystem level.

Please advice!

TIA, Sandor

morgalr

An Oracle Directory has an underlying OS directory associated with it, Oracle just overlays it's control structure onto an existing folder in the OS. You can manipulate the files with stored procedures in Oracle or at the OS level from outside of Oracle.

If you manipulate the files from the OS level, outside of Oracle, you may need a refresh of the Oracle Directory structure.