Copy table improvement

In copying tables from one database to another, now you copy
table a from db A to table a in db B. Is it possible to copy table a from
db A to db B and have that table renamed to b in the same
operation. This avoids overlayng table a in db B if it exists.

Are you referring to Schema browser -> select a table (or multiple) -> right-click -> create -> in another schema?

There is a "drop statement" option, which if unchecked, will prevent tables from being overwritten.

I think auto-renaming could get tricky and perhaps confusing, especially if multiple tables are involved and some already exist and some do not.

2 databases A and B, table a is in both A and B. Want to copy a from A
to B and give it another name, say aa. Then you compare a with aa
should be the same but if not you can flip names other options

I understand where the tables are, but I don't really understand the workflow in Toad you are following.

Can you post some screen shots showing what you are doing in Toad?

Thanks.