Moving table to another tablespace in primary server oracle 11g

oracleoracle-11g-r2

What will be the effect on dataguard configuration when moving one table to another tablespace using the impdp remap_tablespace parameter?

In our production environment we have setup dataguard and I am curious that if move a table in primary what will be effect on dataguard or what steps should I do before the moving table.

Best Answer

If you have configured Data Guard properly, this will not cause any problem. And by 'properly', I mean FORCE LOGGING is enabled. Data Pump can use direct path load (in which case there is minimal redo generated), but there are several conditions that will prevent it:

Situations in Which Direct Path Load Is Not Used

Anyway, to check FORCE LOGGING:

select force_logging from v$database;

If the result is NO, you can enable it with:

alter database force logging;

Note that, this should be done on the primary and all standby databases as well (just in case a role transition happens and a standby becomes primary).

Related Question