Toad World® Forums

clone a user


#1

how to create userB just like userA in TOAD? 12


#2

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


#3

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!


#4

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.

Thanks,
Alan


#5

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.


#6

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.


#7

Thank you John! WHERE IS ALL OF THE GOOD TOAD DOCUMENTATION?

-MG

Marvin Griffin

SR Oracle Applications DBA

O: 301-206-8336
|
C: 240-636-3010
| E:
marvin_griffin@wsscwater.com

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

www.wsscwater.com

  • 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 [mailto:bounce-jdorlon@toadworld.com]

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

To: toadoracle@toadworld.com

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.

Or
Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#8

Help -> Contents?

Google or Toadworld search?

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