CREATE OR REPLACE DIRECTORY - help
800252Oct 1 2010 — edited Oct 1 2010Hello Everyone,
I am running a PL/SQL using "user1" credentials and would like to write the output to a CSV file using UTL_FILE.FOPEN('EXTRACT_DIR','output.csv','w');
The directory 'EXTRACT_DIR' points to my local file system [where "user1" does not have access] and not on the DB server. So, when I run the PL/SQL, it throws the below error:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
ORA-06512: at line 21 <-- UTL_FILE.FOPEN('EXTRACT_DIR','output.csv','w');
DB Version being used: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit
Client Tool: Toad
I am looking for a solution so that I can write the output to my local system directory without modifying the init.ora file on the DB server.
If there's anoter way, please suggest.