The Set Loader is one component in a suite of applications used to accomplish the task of building a smaller Oracle Database from the contents of a larger one. For a step-by-step guide to DataBee and the tools and processes involved please see the DataBee manual home page. If you are unsure about what an Extracted Set File is and where they are generated please see the help for the Set Extractor application.

The DataBee Set Loader Application

As with all DataBee applications, the Set Loader presents its global functions (loading, saving, exiting etc.) as a column of buttons in the right hand side of the application window. The tabs on the top left are used to provide areas of major functionality where the current load can be monitored. Along the bottom of the window are three status line areas where DataBee provides information about its current state.

The Global Functions

The Bee Logo Button

The Bee Logo button brings up an "About" dialog box which provides information on the DataBee version and support contact information.

Acquire Extracted Set

The Set Loader application uses the contents of the binary Extracted Set File to determine which rows should be loaded into the destination schema. This button will make the contents of the Extracted Set File available to the Set Loader. Extracted Set Files are produced by the Set Extractor application.

Load Wizard

The Load of an Extracted Set File is a fairly complicated operation composed of a number of steps which must be performed in sequence. In order to reduce the complexity of the process the Load Wizard was written. It consists of a set of dialog boxes which perform each step of the load process in a logical order. The load steps can be performed manually if desired - simply use the buttons on the Tools & Info. tab.

Reports

The Reports button will write out an itemised report of the rows which have been loaded into the destination schema. This option is quite useful for maintaining written records of the destination database creation.

Save ROWID's to Files

This button will start a wizard that offers to write the ROWID's of the source Oracle database schema tables out to files. The ROWID's can be written to one or more files on a table by table basis and a number of output options are available. This tool is very useful if a manual (or partial) transfer of rows from the source to the destination schema is desired.

Schemas in Set

The Schemas in Set tab tells the Set Loader application the names of the destination Oracle users. These are the schemas which will be loaded by data contained in the Extracted Set File. Please see the specific Schemas in Set tab page for detailed information on this topic.

Table Statistics

The Set Loader application keeps an accurate count as the rows are loaded into the destination Oracle database. This tab shows a continuously updated display of the number of rows loaded for each table. Please see the specific Table Statistics tab page for detailed information on this topic.

Tools & Info

This Tab contains a variety of tools to assist with the generation of rules and to identify the relationships between tables. Please see the specific Tools & Info. tab page for detailed information on this topic.