создание STREAM ADMIN

CREATE TABLESPACE STREAM_TBS DATAFILE '+ASMDATA' 
  SIZE 1G REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

CREATE USER stream_admin IDENTIFIED BY <password>
   DEFAULT TABLESPACE stream_tbs
   QUOTA UNLIMITED ON stream_tbs;

GRANT CONNECT, RESOURCE, DBA TO stream_admin;

BEGIN
  DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE(
    grantee          => 'stream_admin',    
    grant_privileges => true);
END;
/

COMMIT
/