1. ORA-31631 错误的含义 ORA-31631 错误表明在执行 Oracle Data Pump 操作时,当前用户缺乏必要的权限。这通常与 Data Pump 导出(expdp)或导入(impdp)操作相关,特别是当涉及到特定权限要求时。 2. 可能导致 ORA-31631 错误的常见原因 权限不足:执行导出或导入操作的用户没有足够的权限。例如,当尝试执行 REMAP_...
说他在使用了impdp导入数据的时候，使用了TABLE_EXISTS_ACTION=REPLACE这个选项，结果现在数据都给覆盖了。
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_...
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 1. 导入时报错 ORA-31631: privileg...
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
ORA-31631: 需要权限 ORA-39149: 无法将授权用户链接到非授权用户 C:\Users\**>expdpwindqry/**@windcopynetwork_link=linkto95wind directo ry=exp_wind_dir dumpfile=wind.dmp logfile= expdpwind.log Export: Release 11.2.0.1.0 - Production on 星期二 8月 5 10:22:06 2014 ...
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....
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 ...
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...