Forum Stats

  • 3,769,696 Users
  • 2,253,009 Discussions
  • 7,875,155 Comments

Discussions

Reading file from oracle directory at client side

fehers
fehers Member Posts: 85 Bronze Badge
edited Sep 25, 2014 1:40PM in Java Desktop Applications

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

Answers

  • morgalr
    morgalr Member Posts: 457

    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.

This discussion has been closed.