GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Altering and moving a table side effects

edited Nov 25, 2024 4:51PM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered ✓

Hi,

Oracle database 19.24

Goldengate Integrated architecture - 19.24

I would like to know the side effects or issues in altering and moving a table(alter table move) in GG only in target side where it's being replicated not source.

I want to change inittrans & pct_free of the table and move it to and rebuild indexes.(Replicat process configured in target and this table is involved)

Shall i just simply stop replicat and complete activity in target database and start it ?

Will it cause any issues in golden gate replication ?

Note:- We are not touching anything on primary(source).

Thank you !

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