Re: remove & move a user

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: 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: Ora NT DBA
  INET: orantdba_at_netscape.net

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