Using a script for migrating objects

You may have noticed that there is a script for most of the chapters to install the database objects. In this final recipe, we will look at the script and how you can modify it to install any database object.

How to do it...

The following screenshot shows the header of the script. It provides details of the script, what it does, and how to run it. It also contains revision details:

The following code shows the parameters that are passed into the script. We pass in the apps username and password in the format apps/<appswd> (this could be another user if running the script from another schema; however, it is preferable to grant permissions to the apps user, so that the script can be run from the apps user while providing the schema notation before the object is owned by another schema, for example, XXHR.TABLE_NAME).

Note

This is one parameter without spaces. The second parameter is where the script will look for the installation files. If no parameter...