John, Thanks. I forgot to mention that. All indexes on any tables which are moved have to be rebuilt, even if the indexes stay in the same tablespace.
Dennis Ora NT DBA wrote: > > You may also possibly need to rebuild the indexes to a different tablespace. > > John > > Dennis M. Heisler wrote: > > >To remove a user: > >drop user xxx cascade; > > > >To move a user to another tablespace: > > Ensure user has enough quota on tablespace yyy > > > > Set user's default tablespace > > alter user xxx default tablespace yyy; > > > > For each table owned by xxx, > > alter table xxx.aaa move tablespace yyy; > > > > > >Dennis > > > > > >MURAT BALKAS wrote: > > > > > >>Hi, > >> > >> what's the best method to > >> > >>1) remove a user absolutely. I want to remove the user's tables, indexes, > >>... etc. > >>2) move a user absolutely to another tablespace. > >> > >>Thanks, > >> > >>Murat > >> > >>-------------------------------------- > >>Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda ozel > >>haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji > >>geri gonderiniz ve sisteminizden siliniz. Rt.Net Internet Hizmetleri > >>Pazarlama ve Ticaret A.S. bu mesajin icerigi ile ilgili olarak hic bir > >>hukuksal sorumlulugu kabul etmez. > >> > >>This e-mail communication is intended for the private use of the persons > >>named above. If you received this message in error, please immediately > >>notify the sender and delete it from your system. Rt.Net Internet > >>Hizmetleri Pazarlama ve Ticaret A.S. does not accept legal responsibility > >>for the contents of this message. > >>-------------------------------------- > >> > >>-- > >>Please see the official ORACLE-L FAQ: http://www.orafaq.com > >>-- > >>Author: MURAT BALKAS > >> INET: [EMAIL PROTECTED] > >> > >>Fat City Network Services -- 858-538-5051 http://www.fatcity.com > >>San Diego, California -- Mailing list and web hosting services > >>--------------------------------------------------------------------- > >>To REMOVE yourself from this mailing list, send an E-Mail message > >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >>the message BODY, include a line containing: UNSUB ORACLE-L > >>(or the name of mailing list you want to be removed from). You may > >>also send the HELP command for other information (like subscribing). > >> > >> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ora NT DBA > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis M. Heisler INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
