The Server is Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit
Is there an easy & quick way to change the SIDs of the test databases on the server?
Dropping & recreating of the database is an option for me. But I'm looking for something requiring less time.
The other option to assign names in the clients tnsnames.ora is prone to errors, because they are not administrated centrally.
Compared with the time to drop & create a database on SQL-Server, the amount of time required to create a new Oracle database is excessively greater. Further on SQL-Server you can rename SQL-Server instances. [ Usually you rename the server where SQL-Server is running and have some problems until you rename the server too ].