Tuesday, 8 April 2014

ORA-29283: invalid operation

ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
ORA-06512: at "ARBOR.WRITEFILE", line 5
ORA-06512: at line 1




Assume file is already created in the predefined directory with name "file_name.txt"

1. Change the ownership for file:
sudo chown {your user name}: {your user name} file_name.txt

2. Change the mode of the file sudo chmod 777 file_name.txt

now try it should work!!!!