Home » SQL & PL/SQL » SQL & PL/SQL » Exchange partition
Exchange partition [message #265060] Wed, 05 September 2007 06:04 Go to next message
Messages: 51
Registered: January 2006
I have a partitioned table Tab1 with local indexes. And a non-partitioned table TAB2 without any indexes.

Now if I exchange the TAB1's one partition with TAB2
"ALTER TABLE TAB1 EXCHANGE PARTITION P1 WITH TABLE TAB2", my indexes a re going unusable and forces me to rebuild the index. Is there any option to keep index valid while exchanging itself.
(Like we have UPDATE GLOBAL INDEXES for Global indexes).

thanks in advance,
Re: Exchange partition [message #265077 is a reply to message #265060] Wed, 05 September 2007 06:23 Go to previous message
Michel Cadot
Messages: 65138
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, create the index on the table you want to exchange with.

Previous Topic: constraints
Next Topic: need help in PLSQL
Goto Forum:

Current Time: Thu Aug 17 16:40:20 CDT 2017

Total time taken to generate the page: 0.21833 seconds