DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Utl File

  1. 03-07-2003, 08:08 AM #1
    Vish_mp
    Vish_mp is offline Junior Member
    Join Date
    Jul 2000
    Posts
    7

    Exclamation Utl File

    Is there a way by which I can write MY UTL FIle Output into another UNIX Machine/SERVER and a different PATH?

    Note: Not on the same UNIX machine where Oracle Server resides .This is entirely a diferent UNIX machine.
    Vish M P
    Reply With Quote Reply With Quote
  2. 03-07-2003, 09:48 AM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Sure, mount your remote directory to your local machine. UTL_FILE only cares that the directory "looks" like it is local.
    Jeff Hunter
    Reply With Quote Reply With Quote
  3. 03-10-2003, 06:11 AM #3
    TimHall
    TimHall is offline Senior Advisor
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    FYI. This doesn't work on NT4.0 due to an OS issue. The problem was fixed by Microsoft in Windows 2000.

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog
    Reply With Quote Reply With Quote
  4. 03-10-2003, 09:14 AM #4
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by TimHall
    This doesn't work on NT4.0 due to an OS issue.
    (Odd coincidence I wanted to do this today!) Thanks to sem (Dima) in the tek-tips 8i forum: the solution is to run the Instance and Listener NT services as a non-SYSTEM user, member of the local administrators group and with "log on as a service" priviledge. It works for both mapped drives and "url" format. (tested with 8.1.7.4 under NT 4.0 Sp6a).
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width