performance of recreate oracle user Vs drop objects

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 Received on Tue Jul 29 2003 - 14:46:06 CDT