Hot answers tagged oracle-streams
2
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 => 'nwisxfer',
grant_privileges => false,
file_name => 'grant_strms_privs.sql',
directory_name => ...
Only top voted, non community-wiki answers of a minimum length are eligible
