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.
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.