Our scenario is that we have a development database that is named
saidev.sainath.com. The development team works on this database and creates new applications. They have recently created a human resources application and have placed the required database objects for this application in the HR schema.
In the next phase of the development lifecycle, functional and load testing of the application needs to be performed by the application team, normally in conjunction with the test team. For this purpose, a test database has been created, which is
saitest.sainath.com. The development schema and all its objects (only the structure or metadata) will need to be transferred over to the test database. We will now see the steps required ...