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).
