5 Replies Latest reply: Mar 1, 2012 8:36 AM by John Spencer RSS

    logical directory creation

    Apps Tech
      Hi
      The output file created by a particular program is being generated and being sotred in the path usr/tmp. The DBA has a requirement of saving this generated output file into a particular path which is /"Instance"/data/jdi/ers/outfile. How do we create this path by creating a logical directory
        • 1. Re: logical directory creation
          908002
          create or replace directory d1 as '<path>';

          for this you need create any directory privilge
          • 2. Re: logical directory creation
            Solomon Yakobson
            Not exactly sure what you mean. You need to create Oracle directory object once:
            select instance_name from v$instance;
            and then issue:
            create directory tour_directory_name as '/instance-name-from-above-select/data/jdi/ers/outfile;
            and then you have to create OS directory. Login to database server as oreclae owner (user oracle) and issue:
            mkdir /instance-name-from-above-select/data/jdi/ers/outfile
            SY.
            • 3. Re: logical directory creation
              Apps Tech
              Hi SY,
              Well, thanks for the input, But the DBA does not want a directory to be created. The requirement is to make the output file ie. being generated into the path usr/tmp to be generated into the path "instance-name/data/jdi/ers/outfile";Is here any method of creating the output file in a logical directory that has the path mentioned
              • 4. Re: logical directory creation
                Apps Tech
                Hi SY,
                Well, thanks for the input, But the DBA does not want a directory to be created. The requirement is to make the output file ie. being generated into the path usr/tmp to be generated into the path "instance-name/data/jdi/ers/outfile";Is here any method of creating the output file in a logical directory that has the path mentioned
                • 5. Re: logical directory creation
                  John Spencer
                  Jyothis wrote:
                  Hi SY,
                  Well, thanks for the input, But the DBA does not want a directory to be created. The requirement is to make the output file ie. being generated into the path usr/tmp to be generated into the path "instance-name/data/jdi/ers/outfile";Is here any method of creating the output file in a logical directory that has the path mentioned
                  How are you generating the file in /usr/tmp now? Just do the same thing except use instance-name/data/jdi/ers/outfile instead of /usr/tmp.

                  John