Impact of doing Alter table shrink space in a Physical standby setup
I have been working on 1) alter table shrink space SQL construct, which requires 2) enable row movement.
Could you please let me know how these two instructions behave in an environment which has data guard setup? What will be the impact of running these two commands on primary database and corresponding impact on physical standby? Will the standby work without any issues after these two operations or something needs to be done on standby after shrinking the table on primary database.
Unfortunately I don't have a test setup with standby database where I can test this, hence asking for help.