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.
Thanks,
Alan
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?
-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
-
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
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.
Or
Unsubscribe from Toad for Oracle Forum notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Help -> Contents?
Google or Toadworld search?
There are also books about Toad that you can buy on Amazon.