1. ORA-31631 错误的含义 ORA-31631 错误表明在执行 Oracle Data Pump 操作时,当前用户缺乏必要的权限。这通常与 Data Pump 导出(expdp)或导入(impdp)操作相关,特别是当涉及到特定权限要求时。 2. 可能导致 ORA-31631 错误的常见原因 权限不足:执行导出或导入操作的用户没有足够的权限。例如,当尝试执行 REMAP_...
conn n1/n1 SQL> create directory oradmp as '/home/ora11g/oradmp';
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - ProductionORA-31631: privileges are requiredORA-39149: cannot link privileged user to non-privileged user Solution Target side SQL> conn system/Chennai#123@pdb1 Connected. SQL> grant imp_full_database,exp_full...
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Produc tion With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-31631: 需要权限 ORA-39149: 无法将授权用户链接到非授权用户 解决办法: 授予源数据库用户 exp_full_database 权限...
ORA-31631: privileges are required ORA-39161: Full database jobs require privileges 1. 2. 从报错提示信息来看,是权限不足造成的。当执行expdp操作指定remap_schema参数时,需要具备exp_full_database权限。给rm用户赋予exp_full_database权限。 grant exp_full_database to ...
ORA-31631: privileges are required ORA-39109: Unprivileged users may not operate upon other users' schemas Solution: grant the DBA role or the EXP_FULL_DATABASE role to the user that runs the export (scott) or grant it to the role (expdp_role) that is granted to the user that runs th...
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]: ORA-31631 During Export Using DataPump API
expdp dmt/...@... schemas=doris include=TABLE:\"IN \(\'PROV_ADDRESS\'\)\" directory=CIA dumpfile=TEST2.dmp logfile=TEST2.log ORA-31631: privileges are required ORA-39109: Unprivileged users may not operate upon other users' schemas...
ORA-31631:需要权限 ORA-39149:无法将授权用户链接到非授权用户 bash-3.00$ expdp test/test directory=d_temp dumpfile=jiangsu.dp network_link=test113 logfile=jiangsu.log tables=cat_org Export: Release 11.1.0.6.0 - 64bit Production on星期二, 16 9月, 2008 17:09:10 ...
ORA-31631: privileges are required ORA-39109: Unprivileged users may not operate upon other users' schemas 1.操作语句,目标是导出多个用户下面的部份表, SQL> select * from v$version 2 ; BANNER --- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4....