I have a production schema and for upgrade they have decided to use 3 schema instead of one. For deploying this into production I have to take dump of schema A and import into 3 different schema with different names. Is it possible to do so? And how can it be achieved ?
Eg - Previous production schema name - A New schema names - B , C , D
Can I import dump of schema A into B,C & D?