Re: performance of recreate oracle user Vs drop objects

Dropping and recreating the user can be much quicker. Two simple statements and you are done. But you also lose any privileges, roles, etc that have been granted to thise user. If that is the case, it may be quicker to simply generate a script to drop all of the user's objects.

I'm not sure that anyone can really say one is "better" than the other.

HTH,
Brian

Srinivas wrote:
>
> In our system we need to handle large number of oracle users. Each
> oracle user holds one instance of user datasets. To support
> loading/archiving operations we need to export and import data into
> these oracle users.
>
> My question to you is before importing the data is it
>
> 1) better to delete and recreate the oracle user
>
> or
>
> 2) just drop all the objects in the oracle user
>
> thanks,
> Srinivas

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"