GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

TPCC is running, then create capture and add_outbound, my LCR client start, alert.log show MVDD!

Version:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

GDBNM: ORCLCDB

CDB: CDB$ROOT

PDB: ORCLPDB1

schema:
TPCC  
tables:
BMSQL_CONFIG   
BMSQL_CUSTOMER
BMSQL_DISTRICT
BMSQL_HISTORY
BMSQL_ITEM
BMSQL_NEW_ORDER
BMSQL_OORDER
BMSQL_ORDER_LINE
BMSQL_STOCK
BMSQL_WAREHOUSE

— start a produce as TPCC process

ALTER SESSION SET CONTAINER =ORCLPDB1;

DECLARE

  i NUMBER;

BEGIN

  FOR i IN 80000..100000 LOOP

    -- generate insert SQL

    EXECUTE IMMEDIATE 'INSERT INTO TPCC.BMSQL_CONFIG (CFG_NAME, CFG_VALUE) VALUES (:1, :2)'

    USING 'CFG_' || TO_CHAR(i), 'Value_' || TO_CHAR(i);

    COMMIT;

    DBMS_LOCK.SLEEP(0.1);

  END LOOP;

END;

— build capture first_scn

DECLARE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center