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.