AFAIK, you can't.
If you are on a 10g database, you should consider using Datapump. Datapump has a feature to clone database users (REMAP_SCHEMA), Loads all objects from the source schema into a target schema, and datapump has some interesting performance parameters.
There is no way to rename a user. You will need to do an export-import.
Last Wiki Answer Submitted: August 12, 2011 12:54 pm by carlosdl63,535 pts.