Add Column‑Level Exclusion Support for Oracle Database Mirroring in Microsoft Fabric

Idea

Provide an option in Microsoft Fabric Oracle database mirroring to skip or exclude specific columns during replication, especially Oracle system-generated hidden columns (SYS_NC*).

Problem

Oracle mirroring fails during the initial load when tables contain hidden SYS_NC columns, raising ORA-00904. Currently, users must modify source Oracle databases (for example, drop extended statistics), which is not always acceptable in production environments.

Benefit

• Enables mirroring without source-side schema or statistics changes
• Improves compatibility with enterprise Oracle databases
• Reduces onboarding blockers and support escalations

Suggested Solution

Allow column-level exclusion (or automatic exclusion of hidden columns) during initial load and ongoing replication.