I am running Oracle 11g on a Linux box. I am trying to run the following command to set my streams user grants and other authorizations:
BEGIN DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE( grantee => 'nwisxfer', grant_privileges => false, file_name => 'grant_strms_privs.sql', directory_name => '/usr/oracle'); END; 8 / BEGIN * ERROR at line 1: ORA-23481: unexpected name string "/usr/oracle" ORA-06512: at "SYS.DBMS_STREAMS_AUTH", line 1621 ORA-06512: at line 2
A Google search suggested that I run these scripts:
This did not eliminate the error.
Any advice on how to proceed?