Re: cleanup user's account

From: Komix Hui <huikomix_at_dt.com.hk>
Date: 1997/01/16
Message-ID: <32DEE7AA.735D@dt.com.hk>#1/1

Sunny Siu wrote:
>
> How do I remove user's tables and associated objects and then finally drop
> the account? I know that I can easily drop an account using the Motif-based
> Svrmgr. How about cleaning associated objects?
>

login to SYSTEM oracle user, and issue following command:

DROP USER User_Name CASCADE;

-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Assistant MIS Manager                Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049

Received on Thu Jan 16 1997 - 00:00:00 CST