For testing I would like to create twenty identical databases in the same instance. db1,db2,db3,etc.
I have the original database and backup to use to create these.
What is the best way to go about this?
Also, I would like to create unique username and passwords for each database.
Is there a way to automate this also?