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