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:
Jyothis wrote: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.
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