Chapter 6. Utilities

In this chapter, we will cover the following:

• Setting the environment variables

• Starting and stopping an environment

• Creating a custom schema

• Extracting data using FNDLOAD

• Uploading using FNDLOAD

• Using a script for FNDLOAD

• Using a script for migrating objects

Introduction

In this chapter, we are going to look at some utilities that Oracle provides that will assist you as a developer to migrate code from one environment to another. We will also look at how to create a custom schema for the environment you will be working on. This would normally be done by a DBA, but we will need a custom schema for the work that we will be doing in the book. We will also look at using scripts to help with packaging scripts and running just a single script to load multiple objects.