一直对 DATAPUMP_EXP_FULL_DATABASE 和 DATAPUMP_IMP_FULL_DATABASE 这两个权限有误解,以为是导全库的时候才需要这个权限,翻了文档后才知道,不是的.
Many Data Pump Export and Import operations require the user to have the DATAPUMP_EXP_FULL_DATABASE role and/or the DATAPUMP_IMP_FULL_DATABASE role. These roles are automatically defined for Oracle databases when you run the standard scripts that are part of database creation. (Note that although the names of these roles contain the word FULL, these roles are actually required for all export and import modes, not only Full mode.)
我们可以从$ORACLE_HOME/rdbms/admin/catdpb.sql 一窥该权限的全貌。
-- $ORACLE_HOME/rdbms/admin/catdpb.sql
...
Rem NAME
Rem catdpb.sql - Main install script for all DataPump package body
Rem components
...
-------------------------------------------------------------------------
Rem Set up application roles to to be enabled for privile