Expdp export report ORA-39181 Processing Method

Expdp export report ORA-39181 Processing Method

[Environment] database version: Oracle 11.2.0.3

[Error Log] An error is reported when you use the system user to perform database expdp operations. The details are as follows:

Starting "SYSTEM". "SYS_EXPORT_SCHEMA_01": system/******** directory = dir dumpfile = full20151201.dmp schemas = ADM_JOHN

ORA-39181: Only partial table data may be exported due to fine grain access control on "ADM_JOHN". "TEST"

.. Exported "ADM_JOHN". "TEST" 0 KB 0 rows

[Cause] "ADM_JOHN". "TEST" is used for access control, but the SYSTEM user does not have the access permission, so it cannot be exported;

[Solution 1] Permission issues can be solved through authorization. For general Small Business DBAs, they generally have the permissions of sys and system, so they can authorize the system users.

1. Authorization statement: Grant exempt access policy to system;

[Solution 2] Permission issues can also be solved by sys users;

Expdp \ "sys/oracle as sysdba \" directory = DIR dumpfile = full20151201.dmp schemas = ADM_JOHN;

Summary: In my personal habits, I like to use system users to import and export databases. Therefore, I should first authorize system during export.