Oracle 10g Logical Standby - Can You Break Tables Differently From Master DB?

Question

I have a main database that is used for applications like OLTP. At the moment, we have a separate table replication for many tables to another database, which is used as an instance of reporting.

Soon we are moving to the Data Guard Logical Standby database. What I can not track from google is whether I can change the physical structure of tables in a logical standby mode.

I would like to split many large tables in logical mode to facilitate reporting - the ideal way to do this would be to split the tables in logical standby mode and then the SQL application process can just refresh the tables as normal, but I cannot figure out if this is supported.

Does anyone know if it is possible to change the structure of a table in standby mode to implement partitioning?

Answer 1

It should be possible. I would enable row moving in logical standby partitioned tables if your OLTP application updates the partition key values.

Since you use logical reserve as a reporting database, why not leave “copies” of OLTP tables as they are and create materialized views around them? - You can get additional performance improvements from denormalization and aggregation. It is not necessary that you see performance improvements as a result of simply splitting tables.