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 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. 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.
Thank you John! WHERE IS ALL OF THE GOOD TOAD DOCUMENTATION?
SR Oracle Applications DBA
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 [mailto:email@example.com]
Sent: Tuesday, May 22, 2018 4:23 PM
Subject: RE: [Toad for Oracle - Discussion Forum] 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.