High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Impact of doing Alter table shrink space in a Physical standby setup

Hi All,

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.

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