Tag Info

Hot answers tagged


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.


I was using sqlplus and I forgot to commit the changes. Before the commit, changes appeared only in the source database, but after I had committed them, the destination database got the new data.

Only top voted, non community-wiki answers of a minimum length are eligible