Home » SQL & PL/SQL » SQL & PL/SQL » drop and create index partition [merged]
drop and create index partition [merged] [message #394535] Fri, 27 March 2009 12:56 Go to next message
reachmexyz
Messages: 8
Registered: February 2009
Location: New Jersey
Junior Member
hello all

I have a table which is partitioned by year.
Is there any way i can drop indexes of a particular paritition rather than indexes of whole table.
In my case
i wish to drop indexes of 2008 year partition and load 2008 year data and then recreate only 2008 partition indexes.
Can i achieve this.

Thanks
Re: drop and create index partition [message #394538 is a reply to message #394535] Fri, 27 March 2009 13:01 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Do you have local or global indexes?
Re: drop and create index partition [message #394552 is a reply to message #394538] Fri, 27 March 2009 14:26 Go to previous messageGo to next message
reachmexyz
Messages: 8
Registered: February 2009
Location: New Jersey
Junior Member
currently we have global indexes.
But if i can drop and recreate indexes of a particular parition, i can create local indexes.
rebuild index for a partition [message #394859 is a reply to message #394535] Mon, 30 March 2009 10:54 Go to previous message
reachmexyz
Messages: 8
Registered: February 2009
Location: New Jersey
Junior Member
Hello All

I have a table which has around 10 million records for each month.
When i am doing a monthly into that table, i wish to drop or unusable the indexes and after load is complete create or rebuild the indexes.
As the table is huge, dropping and creating indexes on the whole table is tedious.
So i wish to partition the table monthly and when loading
"drop or Unusable the index for that month partition, Load the data, then create or build the index for that month Partition"
Can i achieve this.
Can i alter the index for a particular partition?
Previous Topic: STAR - PROGRAM
Next Topic: definers rights
Goto Forum:
  


Current Time: Sat Dec 10 11:11:28 CST 2016

Total time taken to generate the page: 0.11184 seconds