Re: User Cloning

Mahesh Anand wrote:
>
> Hi Guys,
>
> I need to clone a user to other user how can I do that. I mean clone is
> I want to copy all objects, relations data belongs to one user to be
> copied to other user. does anyone have such kind script or is there any
> facility in oracle to clone user. I am using 7.3.3 on NTMahesh ,

   You could create the user and use the imp/exp utilities . Export the first user. Then import the user using fromuser touser, and rows parameters .

Good luck.

-- 
================================================================
============================
| Joseph Sumalbag                                                                           
|
| Oracle DBA                                                                                
|
|                                                                                           
|
| The opinions expressed above are my own and doesn't 
 necessarily                           |
|reflect the opinion of any of my client company or my employer.                            
|
================================================================
============================