Pages

Saturday, April 16, 2016

Export/Import DataPump: The Minimum Requirements to Use Export DataPump and Import DataPump (System Privileges)

Export/Import DataPump: The Minimum Requirements to Use Export DataPump and Import DataPump (System Privileges)

In Oracle10g, the new database export and import utilities Export DataPump (expdp) and Import DataPump (impdp) were introduced.

Minimum Requirements.

The minimum requirements to run an Export DataPump or Import DataPump job on an Oracle10g or any higher release database are:

- system privilege CREATE SESSION (or the old role: CONNECT)
- system privilege CREATE TABLE
- object privileges READ and WRITE on an valid directory object (or the CREATE DIRECTORY privilege with which a valid directory object was created)
- sufficient tablespace quota on the user's default tablespace (needed to create the so-called Master Table that is used by the DataPump job).

In addition, the role EXP_FULL_DATABASE is needed:

- to run a full database Export DataPump job or
- to run a transport_tablespace Export DataPump job or
- to run an Export DataPump job with the TRACE parameter or
- to run an Export DataPump job that exports a different schema.

In addition, the role IMP_FULL_DATABASE is needed:

- to run a full database Import DataPump job or
- to run a transport_datafiles Import DataPump job or
- to run an Import DataPump job with the TRACE parameter or
- to run an Import DataPump job that imports a different schema.

Note that these requirements apply to the user that connects to the database when running the Export DataPump or Import DataPump job, not to the user that is exported/imported.

No comments:

Post a Comment