Re: remove & move a user

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: murat.balkas_at_o2.net.tr
>
> 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: ListGuru_at_fatcity.com (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: dheisler_at_binghamton.edu

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: ListGuru_at_fatcity.com (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).