Toad World® Forums

clone a user


how to create userB just like userA in TOAD? 12


Find the user in the Schema Browser. RIght-click. Choose Clone/Copy.


That’s nifty - I did not know about the right click option.

Also extremely handy, and lets you copy/clone a user from one db to another: use the Create Script, replace all the username with whatever you like, pop in the new pw, and run as needed. Works great!


Not to sound greedy :slight_smile: but is there a way to clone an entire schema?

Currently, I’m using a data pump export and import but if Toad could do it that would be very cool.



There are lots of right-click features throughout Toad. Explore that.

If the schema does not contain data, you could use Generate Schema Script.

There is also Data Subset Wizard (you could subset at 100%) as long as you don’t have LONG or any datatype that won’t copy with “create table as select”.

Otherwise, Toad’s got a wizard to guide you through datapump, that may help.


Oh, I use lots of right click options. :slight_smile: Just never noticed the clone/copy. I’ll have to read through the options again; I’m probably a little too quickly going for what I already know.




Marvin Griffin

SR Oracle Applications DBA

O: 301-206-8336
C: 240-636-3010
| E:

Washington Suburban Sanitary Commission, 14501 Sweitzer Lane, Laurel, MD 20707

  • For 100 years, WSSC has proudly served the citizens of Prince George’s and Montgomery counties – providing drinking water that has always met strict Safe Drinking Water Act standards and protecting the environment through vital water resource recovery services.*

Our vision is to be THE world-class water utility, where excellent products and services are always on tap.

From: John Dorlon []

Sent: Tuesday, May 22, 2018 4:23 PM


Subject: RE: [Toad for Oracle - Discussion Forum] clone a user

RE: clone a user

Reply by John Dorlon

Find the user in the Schema Browser. RIght-click. Chose Clone/Copy.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

this post as spam/abuse.


Help -> Contents?

Google or Toadworld search?

There are also books about Toad that you can buy on Amazon.