I'm looking for a way to copy an Oracle user and its data to a new one without dump file.
Google search brings a tip by Steve Karam, which seems to be exactly what I want.
However the page is not accessible to me.
@edited
Thank you for your answers, Justin and Leigh.
I'm considering a simulator of an enterprize system whose database scheme is not designed for it.
In order to apply current situation and to keep the simulated result, I decided to make a cloned database user and execute the simulation on that user.
The simulator will be handled by non-IT person, who could have no knowledge about dump file, so cloning the database must be done internally without any user interaction.
That's the reason why I'm afraid of using export/import tool.
Best Answer
Steve is discussing how to copy a user and that user's grants from one database to another. That wouldn't copy the objects the user owns or the data in those objects.
Why don't you want to use the export and import utilities? Whatever restrictions you have that prevent the use of export and import might prevent you from using other alternatives. You could potentially copy the data over a database link, for example, but that wouldn't generally be preferred to just using export and import. If you want to do this on an ongoing basis, Oracle provides various tools for replicating data-- Streams, materialized views, etc.