[askdba] Re: Global Index on Partition Table

  • From: Thiagoo <thiagoodba@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Wed, 22 Dec 2004 09:42:16 -0800 (PST)

Hi Regis,
 
Thanks Regis..! Sorry, I think I missed your mail..! Thanks for all/any others 
whom I've missed in my list.! It was not intentional..! I subscribed to askdba 
after a very long time..earlier I was there in Lazydba..so many are known(thru 
email) to me ..and from others problems..I learnt more..and even for few 
questions..I used to respond..Pls show me the right direction if I was wrong in 
any of my emails..!
 
Regis I like your way of approaching the problems..and in fact in this group 
I've learnt a lot..as am new to this DBA field. I cant name..but there are many 
persons..who give really good input for me.
 
I've few questions..these are generic..which I faced during my interviews..!
 
[] What's the difference between normal DB(Client Server) and VLDB, which all 
we need to take care as part of DBA responsibility..? Similarly for Client 
server DB vs Datawarehousing DB.
 
[] If a user has just logged in and logged out without doing any transaction, 
can we come to know from any of the data dictionary views?, I know that using 
v$session I can see the currently logged on users.
 
Am looking for DBA Interview questions..unable to find a good one..if you know 
any such..pls forward to me..!
 
Thanks!
-THIAGU

Regis Biassala <Regis.Biassala@xxxxxxxxxx> wrote:
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 
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?




                
---------------------------------
Do you Yahoo!?
 Send holiday email and support a worthy cause. Do good.


Other related posts: