Ownership and privileges

When you load a new database, the user who runs the onload utility becomes the owner. Ownership within the database (tables, views, and indexes) remains the same as when the database was unloaded to tape with onunload.

To load a table, you must have the Resource privilege on the database. When onload loads a new table, the user who runs onload becomes the owner unless you specify an owner in the table name. (You need the DBA privilege for the database to specify an owner in the table name.)

The onunload utility does not preserve synonyms or access privileges. To obtain a listing of defined synonyms or access privileges, use the dbschema utility, which The dbschema utility describes, before you run onunload.