Writing a file to a custom created directory on Oracle Amazon-RDS -


i can connect database via sqlplus

sqlplus stepdba/<password>@steprds.<rds-hash-here>.<region>.rds.amazonaws.com:1521/step 

and trying write file.

according amazonrds documentation regarding oracle, create directory must done rdsadmin.rdsadmin_util.create_directory('my_dir'); have done.

to write file, following:

declare     filehandler utl_file.file_type; begin    filehandler := utl_file.fopen('my_dir', 'test.txt', 'w');    utl_file.putf(filehandler, 'writing file\n');    utl_file.fclose(filehandler); end; / 

which result in error:

error @ line 1: ora-29283: invalid file operation ora-06512: @ "sys.utl_file", line 536 ora-29283: invalid file operation ora-06512: @ line 4 

if try write oracle provided directory data_pump_dir, above snippet executes correctly , file written.

the privileges 2 directories same

select grantee, privilege dba_tab_privs table_name='data_pump_dir' , grantee = 'stepdba'; select grantee, privilege dba_tab_privs table_name='my_dir' , grantee = 'stepdba'; 

in amazon-rds case, can not manipulate file/directory permissions on os level.

i seem missing something, hint appreciated.

hi had same problem. solved using higher version of oracle software: oracle se 1 11.2.0.4.v4 1 causing problems oracle se 1 11.2.0.4.v3


Comments