Results 1 to 6 of 6
  1. #1
    Join Date
    May 2010
    Posts
    4

    Unanswered: UTL_FILE : Extract files on application server

    In our project we are extracting the BLOB objects from a database table. Our script extensively uses utl_file and dbms_lob packages.

    In production environment, database is running on different server and application server from where the code will be executed is different.

    To Summarize we have an application server A . The UNIX shell script will run from this server , call sql file which extracts BLOB objects from database table using UTL_FILE. However database is running on different server. This means UTL_FILE will only write to the server the database is running on. However we need the BLOB files on our application server as they are further processed by the shell script.

    Is there any way that the files are extracted on the application server from where the code is executed.


    We did not face this issue on Test environment as both the application server and database server is just one node in test environment.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    UTL_FILE can only write to filesystem that is local to the DBServer.
    Any possible solution is Operating System dependent & you decided we did not need to know what you have.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Can you setup a NSF share from the database to application server and write to that?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    May 2010
    Posts
    4

    Nfs

    Thanks for the reply. Can you explain a bit more about NFS. gat exactly we will need to do.

    Server A : Application server running the code ( UNIX box)
    Server B : Database server on which database resides ( UNIX box)

    Our code executed from server A is extracting BLOB objects from /data/download/tpf directory.

    Do we need to create similar directory on Server B and mount this directory on Server A.

    Kindly explain as this is a new concept for me.

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Let me google that for you

    ask local Unix System Administrator for assistance
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Sorry, i am slightly dyslexic. NFS, not NSF
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •