Reading file from oracle directory at client side — oracle-tech

    Forum Stats

  • 3,702,018 Users
  • 2,239,547 Discussions
  • 7,835,716 Comments

Discussions

Reading file from oracle directory at client side

fehersfehers Posts: 82
edited September 2014 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

  • morgalrmorgalr 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.