About Oracle Tables and Views Load Sets

Oracle Tables and Views Load Sets enable you to access data in Oracle LSH from any Oracle system external to Oracle LSH. The source of the data in the external system can be either a database table or a view with column data types of varchar2, number, and date.

The adapter loads the primary key definitions of the source tables to the target Table instances when you define a Load Set.

You can take two approaches to Oracle data in Oracle LSH:

• Load the physical data into Oracle LSH. Rerun the Load Set periodically to refresh the data in Oracle LSH.

• Define the Load Set's target Table instances as a pass-through view, so that the physical source data remains in the external Oracle system. This approach allows you to minimize data storage space.

  Programs can use Table instances defined as pass-through views as sources just as they can Table instances that contain data. When you run the Program, it reads data in the source system and can write data to Oracle LSH Table instances.

  You specify whether to use the Load Set to load or view data as part of the definition of the target Table instance to which you map the Table Descriptor. The system adds the Create Table as a View option to the Process Type drop-down list of the Table instance after you map the Table instance to an Oracle-type Load Set.

  Note:

  All target Table instances of the Load Set must be defined the same way—either as pass-through views or not. If some are defined as pass-through views and others are not, execution of the Load Set fails.