[askdba] Re: Global Index on Partition Table

  • From: Thiagoo <thiagoodba@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Wed, 22 Dec 2004 07:33:24 -0800 (PST)

Thanks Ganesh & Patricia. Caught on some other problem, so couldn;t respond to 
you immediately!
Patricia Eyenga <patricia.e@xxxxxxxx> wrote:
Adding a partition does not invalidate the index, though... Only =
that drop partitions with data (in versions pre-9i) will invalidate a =
index. (local indexes *should* not be invalidated by partition drops,
although we ran into a bug that made it so..)
You do not need to create a new global index when you add a new =

-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx] =
Behalf Of Ganesh Raja
Sent: Monday, December 13, 2004 4:59 PM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: Global Index on Partition Table


It will help to know the DB Version.=20

From 9i I think there is a Way to Maintain Global Indexes as part of
Partition Maintenance.



On Mon, 13 Dec 2004 13:49:16 -0800 (PST), Thiagoo 
> Hi All,
> One of my colleague is facing a problem..so need you advice.
> I'm having a table with few partitions with Global Index on it and for =

> the next year 2005, I need to add another partition and Global index , =

> what's the best way to do it?
> One way which strikes for me instantly is 'alter table add partition'=20
> and later to drop the index and create new global index..is there=20
> anyway to rebuild the index,without dropping the existing index?
> I will be doing in dev and later on prod. Each partition may have=20
> 3-4GB of data.
> Thanks!
> -Thiagu
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail - 250MB free storage. Do more. Manage less.

Thanks & Best Regards,

Do you Yahoo!?
 The all-new My Yahoo! ? What will yours do?

Other related posts: