Re: remove & move a user

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

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