Schema comparison

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 ...

Get Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.