[askdba] Re: Global Index on Partition Table
- From: "Patricia Eyenga" <patricia.e@xxxxxxxx>
- To: <askdba@xxxxxxxxxxxxx>
- Date: Wed, 22 Dec 2004 11:42:31 -0500
Yeah, what about Regis? He needs love too!!!!
-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx] On
Behalf Of Regis Biassala
Sent: Wednesday, December 22, 2004 11:24 AM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: Global Index on Partition Table
Thanks Ganesh and Patricia..what about me ????
-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx] On
Behalf Of Thiagoo
Sent: 22 December 2004 15:33
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: Global Index on Partition Table
Thanks Ganesh & Patricia. Caught on some other problem, so couldn;t respond
to you immediately!
-THIAGU
Patricia Eyenga <patricia.e@xxxxxxxx> wrote:
Adding a partition does not invalidate the index, though... Only =
operations that drop partitions with data (in versions pre-9i) will
invalidate a = global 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 = partition.=20
-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx] = On
Behalf Of Ganesh Raja
Sent: Monday, December 13, 2004 4:59 PM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: Global Index on Partition Table
Thiagoo,
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.
HTH
Cheers
Ganesh
On Mon, 13 Dec 2004 13:49:16 -0800 (PST), Thiagoo
wrote:
> Hi All,
>=20
> One of my colleague is facing a problem..so need you advice. =20
> 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?
>=20
> 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? =20 I will be doing in dev and later on prod. Each
>partition may have=20 3-4GB of data.
>=20
> Thanks!
> -Thiagu
>=20
>=20
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail - 250MB free storage. Do more. Manage less.
>=20
>
==================================================
Thanks & Best Regards,
Thiagu
==================================================
---------------------------------
Do you Yahoo!?
The all-new My Yahoo! - What will yours do?
Other related posts:
