Oracle Streams Setup Error
You need to create an Oracle DIRECTORY first.

CREATE DIRECTORY MYSTREAMSDIR as '/usr/oracle';

GRANT READ, WRITE ON DIRECTORY MYSTREAMSDIR TO YOURUSER;

BEGIN
  DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE(
    grantee          =&gt; 'nwisxfer',    
    grant_privileges =&gt; false,
    file_name        =&gt; 'grant_strms_privs.sql',
    directory_name   =&gt; 'MYSTREAMSDIR');
END;


The grant isn't needed if you create the directory logged in as the streams admin user (usually strmadmin).