Results 1 to 9 of 9

Thread: init.ora

  1. #1
    Join Date
    Dec 2006
    Posts
    2

    Unanswered: init.ora

    Dear All,
    I have a procedure that uses utl_file to read a .csv file.
    It is required to have .csv file located on server and the path entry should be in init<sid>.ora file. Is there any way so that it is not requierd for me to put the path entry in init.ora file ? I am using HP Unix as operating system.

    Pls can anyone help me with this asap.

    Regards
    Ankit

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Is there any way so that it is not requierd for me to put the path entry in init.ora file ?
    NO!
    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
    May 2004
    Location
    Dominican Republic
    Posts
    721
    It depends on your version. If you are on 9i and above, UTL_FILE can write to a directory Object, which you can create via SQL.

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking


    -- Or -- You can set the UTL_FILE_DIR to some "root" path and allow the server permissions to kick in.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  5. #5
    Join Date
    Nov 2006
    Location
    Indianapolis
    Posts
    90
    To clarify - you do mean "root" in quotation marks - an application directory where your app can do whatever it wants

    not to be confused with setting utl_file_dir to root / or $ORACLE_HOME, or any other critical area...

  6. #6
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Lightbulb


    Yeah, bad choice of word this "root"; I should have clarified I meant some "Application" path where anything goes.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  7. #7
    Join Date
    Dec 2006
    Posts
    2
    Thanks for the reply!!!

    I am using oracle 9i. As susggest that UTL_File can write to a directory object, will this directory should exist on server or client. If on server, is there any way to create directory object on client.

    Thanks in advance for your answer.

  8. #8
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking

    Quote Originally Posted by AnkitBhandari
    ... If on server, is there any way to create directory object on client.

    Not unless the client corresponding file-system is "mounted" on the server.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  9. #9
    Join Date
    Jul 2003
    Posts
    2,296
    has to be on local database server. just take a second to think about it.
    you could make a shared mount point or some-such.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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