Hot answers tagged oracle-streams
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 => ...
XE does not support Streams, as officially documented. SE and SE1 support Streams but without redo capture. EE and PE (Personal Edition) fully support Streams, and also support Logical Standby.
Only top voted, non community-wiki answers of a minimum length are eligible