Re: cleanup user's account

drop user <username> cascade; works great if the user's tables are small and your rollback segment is big enough to handle the command. Plus it's slow for an account with large amount of data. You might want to do the following before issuing the drop user <username> cascade command:

1. Disable all the tables' referential integrety for that user.
2. Truncate all tables.
3. Issue drop user <username> cascade;

I do the above step all the time for development users and it's much faster.

Minh Giang
mpg_at_fast.net

Sunny Siu <xxsiu_at_gamma.uta.edu> wrote in article <5blgs6$1g5_at_news.uta.edu>...
>
> 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?
>
>
> Thanks for your suggestions.
>
> --Sunny Siu
> University of Texas at Arlington
> siu_at_uta.edu
>
>
>
Received on Sun Jan 19 1997 - 00:00:00 CST