Installing the database objects

Create the database objects for this chapter before you start, by using a script provided. The code comes with the Readme_7_1.Txt readme file.

How to do it...

We are going to create a number of objects that we will use throughout the chapter. For all the database objects, there is a script provided called 7126_07_01.sh. The following steps explain of how to run the script:

1. Create a local directory C:\Packt\Scripts\Ch7, where the scripts are downloaded to.

2. Open PuTTY and connect to the Application Tier user.

3. Create a new directory on the Application Tier under $XXHR_TOP/Install with the following commands:

   cd $XXHR_TOP/Install
   mkdir Ch7

4. Navigate to the new directory with the following command:

   cd Ch7

5. Open WinSCP and transfer (ftp) the files from C:\Packt\Scripts\Ch7 to $XXHR_TOP/Install/Ch7.

6. In Unix, change the permissions of the script with the following command:

   chmod 775 7126_07_01.sh

7. Run the following command to create all of the database object commands:

   ./7126_07_01...