tag:blogger.com,1999:blog-4092304359380397372.post2835460745512101575..comments2023-06-19T16:34:10.147+05:30Comments on Apun's Weblog: Oracle Partitioning - Exchange PartitionApun Hiranhttp://www.blogger.com/profile/04745021360458270341noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4092304359380397372.post-24416406960169267422012-08-09T06:28:00.993+05:302012-08-09T06:28:00.993+05:30As per my test. The indexes remain in USABLE state...As per my test. The indexes remain in USABLE state.Apun Hiranhttps://www.blogger.com/profile/04745021360458270341noreply@blogger.comtag:blogger.com,1999:blog-4092304359380397372.post-55030216247709054992012-08-01T12:26:06.044+05:302012-08-01T12:26:06.044+05:30Hi,
I'm confused. When we exchange partition ...Hi,<br /><br />I'm confused. When we exchange partition (INCLUDING INDEXES WITHOUT VALIDATION) with non-partitioned table and ALL the indexes in the partitioned table are LOCAL, do the indexes become UNUSABLE ?hanbarhttps://www.blogger.com/profile/08747661650855780510noreply@blogger.com