Oracle7 Server Utilities

Prerequisites

To load data using the conventional load method, the tables to receive the data must already exist in the database. There are no special requirements for these tables. The tables may be clustered or indexed, or they may actually be a view for which you have insert privileges. Tables may already contain data, or they may be empty.

Privileges Required

The following privileges are required for a conventional load:

You must have INSERT privileges on the table to be loaded.

You must have DELETE privilege on the table to be loaded, when using the REPLACE option to empty out the table's old data before loading the new data in its place.

In addition to the above privileges, you must have write access to all labels you are loading data into a Trusted Oracle7 Server database. See the Trusted Oracle7 Server Administrator's Guide.