Jump to content
killerDBA

Index missing in Logical standby

Recommended Posts

Dear Experts,

Previously a table was existing  on both primary and logical standby with index on one of the column

I have recreated this table(I exported the table and imported with 'indexes=no' option on primary)

I have manually created the index(with logging option) on the primary table  but which is not getting reflected on logical standby. what could be the reason?

or is this a logical standby feature ?..can I manually create the same index on logical standby?

Please help

 

 

 

Share this post


Link to post
Share on other sites

Hi Killer,

Excellent question!

If you think about it, the redo logs for a “create index” statement would consist of hidden tree structures inside the table space.

Since the data blocks will always be different between primary and standby, it would be impossible to propagate across databases.

Plus, would you really want to trigger an index build automatically?

Of course you can create the index manually on the logical standby!

Hope this helps. . .

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×