Oracle XStream

ALTER SESSION SET CONTAINER = CDB$ROOT;

ALTER SYSTEM SET enable_goldengate_replication=TRUE SCOPE=BOTH;
ALTER SYSTEM SET streams_pool_size=256M SCOPE=BOTH;
ALTER DATABASE FORCE LOGGING;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

ALTER SESSION SET CONTAINER = CDB$ROOT;

CREATE USER <cdc_user> IDENTIFIED BY "<password>"
  DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS CONTAINER=ALL;

ALTER USER <cdc_user> SET CONTAINER_DATA = (CDB$ROOT, <pdb>) FOR CDB_TAB_COLUMNS CONTAINER = CURRENT; 
ALTER USER <cdc_user> SET CONTAINER_DATA = (CDB$ROOT, <pdb>) FOR CDB_CONSTRAINTS CONTAINER = CURRENT; 
ALTER USER <cdc_user> SET CONTAINER_DATA = (CDB$ROOT, <pdb>) FOR CDB_CONS_COLUMNS CONTAINER = CURRENT;

GRANT CREATE SESSION, SET CONTAINER TO <cdc_user> CONTAINER=ALL;
GRANT LOGMINING TO <cdc_user> CONTAINER=ALL;

BEGIN
  DBMS_XSTREAM_AUTH.GRANT_ADMIN_PRIVILEGE(
    grantee                 => '<cdc_user>',
    privilege_type          => 'CAPTURE',
    grant_select_privileges => TRUE,
    container               => 'ALL'
  );
END;
/

BEGIN
  DBMS_XSTREAM_AUTH.GRANT_ADMIN_PRIVILEGE(
    grantee                 => '<cdc_user>',
    privilege_type          => 'APPLY',
    grant_select_privileges => TRUE,
    container               => 'ALL'
  );
END;
/

GRANT EXECUTE ON DBMS_XSTREAM_ADM TO <cdc_user>;
GRANT EXECUTE ON DBMS_CAPTURE_ADM TO <cdc_user>;
GRANT EXECUTE ON DBMS_AQADM TO <cdc_user>;
GRANT EXECUTE ON DBMS_AQ TO <cdc_user>;

ALTER SESSION SET CONTAINER = CDB$ROOT;

EXEC DBMS_XSTREAM_ADM.START_OUTBOUND('<outbound_server_name>');

BEGIN
  DBMS_XSTREAM_ADM.START_OUTBOUND(server_name => '<outbound_server_name>');
END;

ALTER SESSION SET CONTAINER = <target_pdb>;

ALTER TABLE <schema>.<table> ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

EXEC DBMS_CAPTURE_ADM.PREPARE_TABLE_INSTANTIATION('<schema>.<table>','all');

BEGIN
  DBMS_CAPTURE_ADM.PREPARE_TABLE_INSTANTIATION(
    table_name          => '<schema>.<table>',
    supplemental_logging => 'all'
  );
END;

GRANT SELECT, FLASHBACK ON <schema>.<table> TO <cdc_user>;

ALTER SESSION SET CONTAINER = CDB$ROOT;

ALTER SESSION SET CONTAINER = CDB$ROOT;

SELECT server_name, connect_user, capture_name FROM all_xstream_outbound;

SELECT capture_name, status FROM dba_capture WHERE capture_name LIKE 'CAP$_SSTREAMS%';

SELECT username, privilege_type, grant_select_privileges FROM dba_xstream_administrator WHERE username='<cdc_user>';

SELECT name, value FROM v$parameter WHERE name IN ('enable_goldengate_replication','streams_pool_size');