Oracle Load Set Attributes

Click Update and enter values for the remote location and database schema that are the source of the data to be loaded:

• Remote Location. Click the Search icon and choose a source remote location/connection combination from the list of values. The system displays only those locations and connections to which you have security access.

  If the location you need is not on the list, ask a system administrator to create a defined Remote Location for it in the Administration user interface.

  If you have a valid username and password for the required database, you can create a connection in the Preferences hyperlink at the top of most Oracle LSH screens. However, you cannot create a connection until an administrator has created a remote location.

  Your company may also use shared connections. If so, you can use those as well.

• Schema. Select the database schema on the remote location where the table or view resides.