Toad for Oracle Base (32-bit)
16.3.231.2085
Unless I'm mistaken, there doesn't seem to be a way to move multiple schema logon records to another database instance.
E.g. I have 20 logon records for schemas on instance DEV1. In light of the growing burden on DEV1, our DBA has moved these to DEV2, maintaining everything including passwords. If I select the 20 schemas on the schema login page and select "Edit selected schema records", there is no option for me to change the Database name, even though they currently share the same DB instance. This seems a considerable flaw in the "Edit selected schema records" form.
My company hosts hundreds of schemas on many instances, we regularly have to move groups of schemas to other instances. Having to edit each login is beyond cumbersome.
Regards
Paul