Re: User Cloning
From: Joseph D. Sumalbag <joseph_sumalbag_at_bose.com>
Date: 1997/11/04
Message-ID: <345F654B.1070_at_bose.com>#1/1
Date: 1997/11/04
Message-ID: <345F654B.1070_at_bose.com>#1/1
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. | ================================================================ ============================Received on Tue Nov 04 1997 - 00:00:00 CET